Database Administrator (Aws)

Position Description
We are looking for a Database Administrator (AWS Focus) with a strong foundation in AWS services and DevOps practices. The ideal candidate will have extensive experience in database management, performance optimization, and cloud-based automation. This role emphasizes not only traditional database administration skills but also the ability to implement modern observability and automation practices.
Key Responsibilities:

• Administer, fine-tune, and scale AWS RDS instances, particularly focusing on Aurora MySQL, to ensure optimal performance, security, and reliability.
• Utilize AWS Athena for advanced data querying capabilities, enhancing data retrieval and analytics processes.
• Manage AWS RedShift clusters, emphasizing on performance tuning, storage optimization, and efficient query processing for our data warehousing needs.
• Apply DevOps methodologies across database operations, including CI/CD pipelines, infrastructure as code, and automated testing, to increase efficiency and reduce downtime.
• Create and manage cloud automation scripts and templates using Terraform or CloudFormation for the efficient provisioning and management of AWS resources.
• Develop UNIX shell scripts to automate database maintenance tasks, backups, and monitoring, ensuring high reliability and performance.
• Program and maintain applications or scripts using Go, Java, and Python, showing a strong ability to adapt to and learn new programming languages as needed.
• Implement Jenkins for CI/CD automation, ensuring smooth and consistent database updates and deployments.
• Manage database schema changes with Liquibase, facilitating seamless transitions and minimizing operational disruptions.
• Execute data migration projects accurately, maintaining data integrity and minimizing impact on production systems.
• Develop and implement global replication strategies to support high availability, disaster recovery, and distributed data access.
• Perform rigorous performance tuning and monitoring of database systems to identify and mitigate bottlenecks, ensuring maximum efficiency.
• Establish comprehensive observability frameworks for real-time monitoring, alerting, and troubleshooting of database environments, improving system transparency and proactive issue management.
• Proficiency in SQL and Query Optimization

Qualifications:

• Proven experience in managing AWS RDS, with a particular emphasis on Aurora MySQL, AWS Athena, and AWS RedShift, including a focus on performance tuning and monitoring
• Understanding of relational database theory
• Experience with NoSQL tools like DynamoDB, Mongo, Redis, Cassandra is a plus
• Strong understanding of DevOps principles and experience with cloud automation tools such as Terraform or CloudFormation.
• Proficiency in UNIX shell scripting, with solid programming skills in Go, Java, and Python, demonstrating the flexibility to learn new languages.
• Experience with Jenkins CI/CD automation and Liquibase for database change management.
• Demonstrated capability in data migration and global replication strategies.
• Excellent problem-solving skills, with an emphasis on optimizing database operations for scalability, performance, and reliability.
• Effective communication skills, able to collaborate across teams and communicate technical concepts to diverse audiences.

Application Process:
Interested applicants should submit a resume highlighting their experience and qualifications in relation to the responsibilities and qualifications outlined. Please include specific examples of past projects involving AWS database services, performance tuning, monitoring, observability, DevOps practices, cloud automation, and programming with Go, Java, and Python.
YOU'LL LOVE WORKING HERE BECAUSE YOU CAN:

• Have courageous team collaboration.Courage comes from how associates are willing to have difficult conversations, speak up, be an owner, and challenge one another's ideas to net out the best solution.
• Deliver at epic scale.We deliver real user outcomes using strong judgment and good instincts. We're obsessed with the art of achieving simplicity with a focus on client happiness and productivity.
• Be surrounded by curious learners.We align ourselves with other smart people in an environment where we grow and elevate one another to the next level. We encourage our associates to listen, stay agile, and learn from mistakes.
• Act like an owner doer.Mission-driven and committed to leading change, you will be encouraged to take on any challenge and solve complex problems. No tasks are beneath or too great for us. We are hands-on and willing to master our craft.
• Give back to others.Always do the right thing for our clients and our community and humbly give back to the community where we live and work. Support our associates in times of need through ADP's Philanthropic Foundation.
• Join a company committed to equality and equity.Our goal is to impact lasting change through our actions.

What are you waiting for?Apply today!
Find out why people come to ADP and why they stay:https://youtu.be/ODb8lxBrxrY
(ADA version:https://youtu.be/IQjUCA8SOoA)
Diversity, Equity, Inclusion Equal Employment Opportunity at ADP: ADP affirms that inequality is detrimental to our associates, our clients, and the communities we serve. Our goal is to impact lasting change through our actions. Together, we unite for equality and equity. ADP is committed to equal employment opportunities regardless of any protected characteristic, including race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, or protected veteran status and will not discriminate against anyone on the basis of a disability. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.
Ethics at ADP: ADP has a long, proud history of conducting business with the highest ethical standards and full compliance with all applicable laws. We also expect our people to uphold our values with the highest level of integrity and behave in a manner that fosters an honest and respectful workplace. Click https://jobs.adp.com/life-at-adp/ to learn more about ADP's culture and our full set of values.