What are the responsibilities and job description for the Senior Database Administrator position at Atem Corp?
- Title: Senior Database Administrator (SQL Server / PostgreSQL / AWS)
- Employment Type: Contract
- Location: Naperville, IL (Weekly 3 days Onsite)
We are seeking a highly experienced, hands-on Senior DBA with strong expertise in relational databases and a solid understanding of AWS cloud architecture. This role requires an individual who can independently plan, design, and optimize database environments while aligning business needs in a cloud-first ecosystem.
Key Responsibilities
Finops activities for DBs and backup services in AWS. Setup end to end observability for DBs, AWS services,
Independently plan, design, and manage relational databases in AWS. Own end-to-end database architecture, performance, and reliability. Implement and manage HA/DR solutions
Perform advanced performance tuning, query optimization, and indexing
Develop SQL enhancements, stored procedures, and data models aligned with business logic
Understand and translate business requirements into efficient database solutions
Experience in migrations and modernization efforts (on-Prem to AWS Platform, Azure to AWS platform, cross-platform where applicable)
Define and execute backup, recovery, and data protection strategies
Ensure security, compliance, and data governance
Automate operational tasks using scripting
Leverage AI-driven tools and capabilities for optimization, monitoring, and productivity
Required Skills & Experience
10 years of DBA experience with significant hands-on expertise
Strong experience in relational databases (preferably SQL Server, MySQL, PostgreSQL)
Experience and expertise across multiple database platforms and ecosystems
Solid Understanding Of AWS Cloud, Including
Amazon RDS
Amazon Aurora
Experience in Redshift / data warehouse environments. Experience in snowflake or similar warehouse systems
EC2-based database deployments.
Cloud architecture, scalability, and cost optimization
Advanced expertise in performance tuning, query optimization, execution plans, and indexing
Strong experience in SQL development and enhancements
Proven ability to understand and implement business logic at the database layer
Experience with database migration tools (AWS DMS, SCT, etc.)
Proficiency in automation/scripting (Python, PowerShell, Bash)
Nice to Have
Experience with data warehousing and analytics platforms
Experience leveraging AI/ML-assisted tools in database operations or engineering workflows
DevOps practices (CI/CD, Terraform, CloudFormation)
Exposure to NoSQL databases
Data governance and compliance experience
Soft Skills
Strong ownership mindset; ability to operate independently
Strategic thinking with deep execution capability
Strong problem-solving and communication skills