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.
|
Genesis10
life insurance, 401(k)
Nov 10, 2024