Advantage Solutions Senior Database Engineer in Chicago, Illinois
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
• 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.
• 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.
• BA/BS in Computer Science or equivalent work experience
• 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.
• 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
The Company is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. The Company services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today.
The Senior Engineer Database is responsible for assisting the National Technology Manager with project management, systems analysis, and other managerial functions, as well as standard Specialist Technology functions, such as systems maintenance and end user support.
The Senior Engineer Database interfaces with multiple members of the Company's IT team and business units on technical and financial systems support level. The Senior Engineer Database demonstrates an enterprise view and understanding of systems and technologies and is responsible for database design, installation, maintenance, monitoring, and upgrades of database systems. This includes documenting systems in accordance with company standards. The Senior Engineer Database serves as a point of escalation and review for issues or concerns identified by the support team or monitoring services on a 24x7 basis.
Essential Job Duties and Responsibilities
Database Technology Solutions Development
Provide development across all supported SQL Server features/components such as High Availability , Disaster Recovery, SQL Server monitoring, Data Collection, and others utilizing T-SQL, PowerShell and .Net development tools.
Focus on further increasing the levels of automation and self-service.
Collaborate with key vendors and Embedded IT teams in providing innovative added value solutions to Company’s SQL Server infrastructure.
Operationalize new SQL Server features
Research new SQL Server features and provide recommendations on their implementation in Company environment.
Participate in designing and implementing new solutions utilizing SQL Server features.
Provide detailed documentation, technical presentations and training for development and support teams.
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.
Other duties as required
This position does not have supervisory responsibilities for direct reports
Does not have direct reports, but may delegate work of others and provide guidance, direction and mentoring to indirect reports
Travel and/or Driving Requirements
Travel and Driving are not essential duties or functions of this job
Education Level: (Required) Bachelor's Degree or equivalent experience
Field of Study/Area of Experience: Information Systems, Information Technology, Computer Science / Engineering or equivalent experience.
5+ years of experience in SQL Server Database Administration
3 + years’ experience as a Senior Professional DBA
3 + years’ experience developing applications in Transact-SQL
Skills, Knowledge and Abilities
Demonstrated strong knowledge of and adherence to SDLC standards
Demonstrated ability to interface with collaborative work groups to resolve service issues
Ability to participate and drive problem resolution and root cause analysis
Ability to analyze situations and develop solutions
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 with a diverse workgroup made up of various cultural backgrounds, both remote and local employees
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 Company on-call rotation
Requires knowledge of but not limited to Microsoft SQL
Proficient in Microsoft Excel (Formulas, Pivot Tables, VLookup)
Microsoft Office including Word, Excel, and Outlook
Microsoft Internet Explorer
Virus Scanning Software
Environmental & Physical Requirements
Office / Sedentary Requirements
Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.
Additional Information Regarding The Company Job Duties and Job Descriptions
Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. The Company shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.
The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of associates so classified.
The Company is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, the Company shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.
Job Locations US-IL-Chicago
Primary Posting Location : City Chicago
Primary Posting Location : State/Province IL
Primary Posting Location : Postal Code 60601
Primary Posting Location : Country US
Requisition ID 2023-430064
Position Type Full Time
Category Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)
Minimum USD $77,583.00/Yr.
Maximum USD $120,000.00/Yr.