DBA Admin

Title: Database Admin

Location : Database Admin in 3 Ravinia Dr NE, Atlanta, GA

Duration: CTH

Job Description:-

Essential Duties and Responsibilities -

• • Provide support for current on-premise footprint of Oracle RAC on Exadata.
  • Willing to learn and support additional Open Source database platforms.
  • Develop standards for and support Cloud implementations of AWS RDS for Oracle, Google Cloud SQL(Postgres) AWS Aurora (MySQL) and other open-source offerings.
  • Contribute to the planning, architecture, design, implementation, standards creation, maintenance, and support of databases on a variety of platforms within a complex Hybrid Cloud systems environment.
  • Perform advanced data analysis, database planning and database coding to develop database environments that meet customer needs.
  • Responsible for enhancements to standards documentation and change management policies while promoting code deployment.
  • Lead and/or participate in Proof-of-Concept efforts for new database technologies.
  • Provide escalation operational support for database systems and participates in on-call rotation.
  • Responsible for building complex and efficient database environments to maximize productivity and improve performance to include reorganization of database structures as needed, procedures automation at regular intervals, use of tools to reorganize or de-fragment database table spaces, tables, and indexes.
  • Manage production testing and QA database environments. This includes providing data load programming, creating necessary utility functions for each data base, system testing and developing an implementation plan.
  • Responsible for designing replication and DR solutions and participate in DR activities.
  • Provide RCA for critical issues in a timely manner.
  • Assist development teams in producing efficient SQL and query tuning.
  • Automation - Develop and support Terraform code used for database deployment and updates.

Technical Skills and Knowledge

• • Advanced knowledge of Oracle database, especially RAC on Exadata or AWS RDS for Oracle.
  • Advanced level in troubleshooting database performance and outage issues.
  • Advanced knowledge of database design and related architecture.
  • Advanced knowledge of the techniques and methodologies of data management systems including relational, network and hierarchical systems.
  • Advanced knowledge of database concepts/design/deployment, recovery techniques, performance monitoring, tuning and capacity management.
  • Advanced knowledge of SQL, including programming and ways to optimize SQL code.
  • Advanced knowledge and understanding of structured analysis and technical design techniques.
  • Advanced analytical and problem-solving skills.
  • Working knowledge of Golden Gate.
  • Ability to learn other database technologies including non-relational database offerings.
  • Experience with Cloud implementations of MySQL and Postgres databases including physical design, SQL tuning, cluster builds, replication, backup, and recovery is a plus.
  • Experience with Cloud monitoring tools such as AWS Cloudwatch/Performance Insights and Google Stackdriver/Query Insights is a plus
  • Advanced project management experience in organizing, planning, and executing large-scale projects from conception through implementation.
  • Effective verbal and written communication skills for providing information to clients, vendors, senior management, and staff.
  • Ability to mentor teams, share knowledge, and mentor junior database staff.

Hot Skills

• AWS Platforms: Aurora MySQL, RDS for Oracle, DynamoDB, Aurora Postgres
• GCP Platforms: Google Cloud SQL(Postgres)
• Automation tooling expertise Terraform, Chef, Ansible, Jenkins, Git, etc.