Sr. Database Administrator

---

Job description

Genesis10 is currently seeking a Sr. Database Administrator with our client in the transportation industry in their Atlanta, GA location. This is a 12 month + contract position.

Description:

Seeking a Sr. Database Administrator

Our client is on a journey to becoming the best IT organization in the airline industry, a journey of transformation. They are changing the way we do business from top to bottom as we strive to create meaningful and innovative solutions and are looking for team members to help us realize our vision

Responsibilities:

Work with customer, deployment squads, and product management to identify and document use case scenarios

Lead on all data solution aspects including setting data standards and provide your deep technical expertise to development teams for best practices, systems, and architectures

Responsible for data analysis and database management, Database automation in AWS with RDS, Lambda using Python

Involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning

Responsible for understanding, configuring, and managing database administration tools

Provides database support for business applications and schedules back up jobs for user databases

Provides access control (password resets/account creation/deletion) and checks IP compliance (violation report review, compliance updates and compliance set ups)

Performs data purging and data replication activities with both on-demand and automated cron jobs

Research on connectivity issues and recurring errors in Application database

Responds to database alerts and takes appropriate actions

Performs database creations

Performs performance tuning and troubleshooting for database

Performs application database maintenance and provides technical assistance to users

Manages database account access and database object changes

Ensures that monitoring and alerts are properly in place to meet monitoring requirements

Performs application database and OS scripting

Reviews Information Protection compliance reports and notifications for individual databases and internal processes (including compliance updates and compliance set ups)

Performs data purging and data replication activities

Performs database recovery from logs, hot and cold backups, Export/Imports and Disaster Recovery

Performs database creation decommissioning and database updates/migrations to a higher/lower version or cross platform migrations

Involved in database, schema, and object refresh activities

Monitors and reports existing database Instance, Database, Server activities for CPU, Memory, and Cache, logs performance, and recommends effective resource utilization/emergency recovery procedures

Implements database security and auditing features and periodic reviews

Conducts root cause analysis for repeated incidents

Performs heterogeneous database interface deployment and support for various data interfaces with applications, Middleware interface and functionality deployment with database architecture

Plans and develops processes for database updates and migrations to a higher/lower version or cross platform migrations

Develops capacity planning processes that include monitoring of existing database Instance, Database, Server activities for CPU, Memory, Cache, Logs performance and recommends effective utilization of resources and emergency recovery procedures

Conducts team training and responsible for resource management

Research new technologies to address operations reliability and compliance

Implements and performs configuration management of database cluster and replications

Requirements:

Bachelor of Science degree in Computer Science or equivalent

10+ years as an Oracle DBA, with expertise in design, implementation, backup, recovery, monitoring, and performance tuning

5+ years expertise with multiple AWS DB Services, Lambda creations for automating multiple DB jobs

5+ years Database automation in AWS with RDS, Lambda using Python, preferable: Oracle, Postgres, AuroraDB

Ability to communicate verbally and in writing with all levels of employees and management, capable of successful formal and informal communication, speaks and writes clearly and understandably for the audience

Strong analytical skills with strong attention to detail and accuracy

Ability to source, disseminate and properly apply secondary research

Expertise in high-availability database features, replication, disaster recovery, and live production schema changes

Proficiency with cloud-specific technologies (S3, Route 53, CloudFormation, AWS CDK, AWS Cloudwatch, AWS RDS, AWS Redshift, DynamoDB, Redis), version control tools (Git), and database life-cycle management

Knowledge of database security, backup retention policies, and scaling databases

Experience with managing the full life cycle of database schema design and implementation, which includes script management from development through production releases

Experience implementing database schema changes in a live production environment requiring minimal downtime and zero performance impact

If you have the described qualifications and are interested in this exciting opportunity, please apply!

About Genesis10:

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10:

Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.

The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.

Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)

Behavioral Health Platform

Medical, Dental, Vision

Health Savings Account

Voluntary Hospital Indemnity (Critical Illness & Accident)

Voluntary Term Life Insurance

401K

Sick Pay (for applicable states/municipalities)

Commuter Benefits (Dallas, NYC, SF)

Remote opportunities available

For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

<!– job description page –>