Database Engineer Senior 1 at RSM US in Hyderabad

Job description

• RSM has an opportunity for a highly motivated Database Administrator with 5 to 6 years of hands-on experience administering Microsoft SQL Server, Azure SQL (Paas), PostgreSQL, Neo4j, and MongoDB environments. The role is responsible for the availability, performance, security, backup, recovery, and operational support of relational, graph, and document database platforms across on-premises and Azure environments. The administrator will also support data-integration needs by setting up and maintaining Azure Data Factory pipelines and developing or enhancing SSIS packages as business and technical requirements arise. This position collaborates with application, infrastructure, security, and data engineering teams to deliver reliable database services, resolve incidents, implement controlled changes, and continuously improve operational processes.

Responsibilities

• Administer Microsoft SQL Server, Azure SQL (Paas), PostgreSQL, Neo4j, and MongoDB platforms, including installation, configuration, patching, upgrades, security administration, capacity management, monitoring, performance tuning, backup and recovery, high availability, and routine health checks. Troubleshoot database incidents and service degradation, perform root-cause analysis, maintain operational documentation and runbooks, and ensure database changes follow established change-management and security procedures
• Support data integration and movement requirements by configuring, maintaining, monitoring, and troubleshooting Azure Data Factory pipelines. Develop, modify, deploy, and support SSIS packages when integration, migration, transformation, or scheduled data-processing needs arise. Work with application and data teams to validate source-to-target mappings, dependencies, schedules, error handling, and operational support requirements.
• Partner with application developers, architects, infrastructure, security, and business technology teams to design and implement database solutions. Review database schemas, queries, indexes, execution plans, data models, and deployment scripts; recommend improvements for reliability, scalability, maintainability, and performance across relational and non-relational platforms.
• Participate in scheduled and unscheduled weekend or after-hours maintenance and production support using established change-management and incident-response procedures. Perform rotational on-call duties, support disaster-recovery exercises, and assist with restoration and service-continuity activities.

Requirements

• Preferred: Bachelor's degree in computer science, Information Systems, Software Engineering, or a related field; equivalent relevant work experience may be considered.
• Microsoft, PostgreSQL, MongoDB, Neo4j, or Azure data certifications are preferred but not required.
• Strong administration skills for Microsoft SQL Server and PostgreSQL.
• 5 to 6 years of hands-on database administration experience, with strong experience supporting Microsoft SQL Server and PostgreSQL in production environments.
• Practical experience administering or operationally supporting Neo4j and MongoDB, including security, backup and recovery, monitoring, maintenance, and troubleshooting.
• Experience supporting production databases for availability, performance, reliability, capacity, and incident resolution.
• Working administration knowledge of Neo4j graph databases and MongoDB document databases.
• Database installation, configuration, patching, upgrades, backup, recovery, security, monitoring, capacity planning, and high-availability support.
• SQL performance tuning, query analysis, indexing, troubleshooting, and system optimization.
• Ability to set up, maintain, monitor, and troubleshoot Azure Data Factory pipelines.
• Ability to develop, enhance, deploy, and support SSIS packages as needed.
• Proficiency with T-SQL and familiarity with PostgreSQL SQL, PowerShell, or other automation/scripting tools.
• Knowledge of Azure data services, Azure DevOps or comparable source-control and deployment practices, and IT service-management processes.
• Experience creating, maintaining, monitoring, and troubleshooting Azure Data Factory pipelines.
• Experience developing and supporting SSIS packages for data integration, transformation, migration, or scheduled processing needs.
• Experience with controlled production changes, patching, upgrades, disaster recovery, documentation, and rotational on-call support.
• Strong collaboration skills and the ability to work effectively with application, infrastructure, security, architecture, and data teams.
• Excellent written and verbal communication skills, including the ability to document technical procedures and explain complex issues clearly.
• Strong analytical, troubleshooting, prioritization, and process-improvement skills.
• Ability to manage multiple priorities, work independently, and respond effectively to production incidents

Skills

Required

• Microsoft SQL Server
• PostgreSQL
• Neo4j
• MongoDB
• Azure SQL (PaaS)
• Azure Data Factory
• SSIS
• T-SQL
• PowerShell
• SQL performance tuning
• Query analysis
• Indexing

Preferred

• PostgreSQL SQL
• IT service-management processes

Benefits

• At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/india.html.