Senior Database Engineer | Job in Chicago, IL. | Advantage Solutions | #2023-430064
Minimum: USD $77,583.00/Yr.
Maximum: USD $120,000.00/Yr.

Senior Engineer Database

As a Senior Database Administrator, you will hold a pivotal role in overseeing and optimizing our diverse database systems, ensuring peak performance, robust security, and high availability. Your primary responsibility will involve the proficient management of Microsoft SQL Server, Azure SQL, Azure Data Factory, PostgreSQL, MySQL, Cosmos DB, and Synapse Analytics. The ideal candidate will possess a minimum of 5 years of experience in database administration, with a strong emphasis on these key technologies.

Areas of Responsibility

Database Management

• Lead the design, installation, configuration, and maintenance of database software.

• Implement robust backup, restoration, and disaster recovery strategies.

• Monitor, fine-tune, and optimize database performance for minimal downtime and maximum efficiency.

• Establish and enforce stringent database security protocols and access controls.

Database Development

• Collaborate closely with application development teams to design and optimize database schemas.

• Offer expertise in writing, tuning, and troubleshooting complex SQL queries, stored procedures, and ETL processes.

• Execute and oversee data migration initiatives when required.

• Develop and execute data migration strategies when necessary

Automation and scripting

• Develop and maintain advanced automation scripts for streamlined database provisioning and management.

• Enhance monitoring and alerting systems to proactively identify and resolve database issues.

Scaling and cloud integration

• Spearhead scalability and high availability efforts for Azure SQL, Cosmos DB, Synapse Analytics, and other cloud-based databases.

• Efficiently manage cloud resources and optimize cost-effectiveness.

Documentation and Reporting

• Maintain comprehensive documentation detailing database configurations, procedures, and best practices.

• Regularly generate performance and usage reports to support informed decision-making.

Problem Resolution and Process Management

• Drive problem resolution and root cause analysis across the technology stack.

• Participate in the resolution of database availability, capacity, and performance issues.

• Contribute to ongoing improvement of internal processes and SQL Server tools.

• Participate in infrastructure and organizational initiatives across multiple IT disciplines.

Education

• BA/BS in Computer Science or equivalent work experience

Requirements

• Proven experience of 5+ years hands-on experience as a Database Administrator.

• Proficiency in managing a diverse range of databases, including Microsoft SQL Server, Azure SQL, and Azure Data Factory.

• In-depth knowledge of database design principles, normalization, and optimization techniques.

• Strong grasp of advanced database security practices.

• Cloud expertise, especially within Microsoft Azure.

• Excellent troubleshooting and technical problem-solving skills. Ability to participate and drive problem resolution and root cause analysis.

• Experience with monitoring tools.

• Proficient at multitasking and proactive in work responsibilities

• Strong written and verbal communications skills including the ability to communicate technical and business information to both technical and non-technical people

• Proven ability to establish strong partnerships with customers, vendors and peers.

• Must be able to work both as a team member and independently in multi-tasking fast-paced deadline driven environment.

• This position is required to participate in the Advantage on-call rotation.

Additional Skills

• Familiarity with PostgreSQL, MySQL, Cosmos DB, Synapse Analytics, Azure Cache for Redis, and Azure Table Storage.

• Mastery of scripting languages (e.g., PowerShell, Python) for automation.

• Ability to work on multiple concurrent complex projects and to coordinate the work of others in the cloud environment

Job Will Remain Open Until Filled

Senior Database Engineer

Apply Now