Senior Database Administrator - Production Support
J
JobgetherDatabase administration
Based in the United StatesFull-TimeSenior
Salary116,450 - 157,550 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- At least 5 years of relevant experience in database maintenance and analysis; candidates with 7 or more years are preferred. An additional 4 or more years of relevant experience may be considered in place of a bachelor’s degree.
- Required Skills
- AWSETLMicrosoft SQL ServerData modelingDatabricks
Requirements
- Have a bachelor’s degree in Computer Science, Computer Programming, Computer Engineering, or a related technical field, with at least 5 years of relevant database maintenance and analysis experience.
- Alternatively, have at least 4 additional years of relevant experience in place of a bachelor’s degree.
- Seven or more years of relevant experience is preferred.
- Have experience supporting production database systems, including shift-based coverage and on-call responsibilities.
- Have strong experience with AWS database technologies, particularly Amazon Aurora PostgreSQL and other AWS-managed data services.
- Have experience with Databricks and familiarity with the AWS cloud platform.
- Have hands-on experience installing, configuring, administering, and supporting database environments.
- Understand data warehousing, data modeling, data mapping, data flow diagrams, and data marts.
- Have experience designing cloud-based database solutions and migrating legacy on-premises databases to multi-cloud or hybrid-cloud environments.
- Be able to investigate complex issues, manage competing priorities, work independently, and contribute effectively in an Agile development environment.
- Be able to collaborate with stakeholders and document technical ideas, implementation plans, and project updates.
- Databricks Certified Data Professional, AWS Certified Database – Specialty, and AWS Certified Solutions Architect – Associate or Professional are preferred.
Responsibilities
- Provide production support for mission-critical database environments, including shift-based coverage and on-call responsibilities.
- Monitor database performance, troubleshoot production issues, coordinate service restoration, and conduct root-cause analysis.
- Install, configure, administer, and maintain database environments, and develop SQL Server objects using SQL Server Management Studio.
- Support AWS database technologies, including Amazon Aurora PostgreSQL and other managed data services.
- Design scalable data models for Databricks lakehouse environments, including layered data models, dimensional models, and curated data products.
- Develop and deploy ETL packages through CI/CD pipelines, using configuration management and version control practices.
- Contribute to data governance, database policies, operating standards, data quality controls, and administration practices.
- Support data modeling, mapping, data flows, data marts, system integration, and migration from legacy on-premises databases to cloud environments.
- Collaborate with technical teams, Product Owners, users, agency leaders, and stakeholders to translate business needs into technical requirements.
- Analyze datasets, perform data validation and peer reviews, and use Atlassian tools and Splunk for log indexing, monitoring dashboards, alerts, and reports.
View Full Description & ApplyYou'll be redirected to the employer's site