Date Posted: 12/03/2024
Hiring Organization: Rose International
Position Number: 475102
Job Title: Senior Database Administrator (DBA)
Job Location: Atlanta, GA, USA, 30320
Work Model: Onsite
Employment Type: Temporary
Estimated Duration (In months): 7
Min Hourly Rate($): 30.00
Max Hourly Rate($): 36.00
Must Have Skills/Attributes: DBA, Oracle, Performance Tuning, PowerShell, Python, SQL Server
Job Description
Minimum Qualifications – Education and Experience:
• Bachelor’s degree in Computer Science, Information Systems, or a related field. Equivalent professional experience may be considered in lieu of a degree.
• 6+ years of professional experience managing SQL Server, Oracle, and MySQL databases.
Preferred Education & Experience:
• Master’s degree in Computer Science, Information Systems, or a related discipline.
• 8+ years of direct experience in database administration across on-premise and cloud environments.
Licensures and Certifications:
Preferred: Not mandatory
• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified Database Administrator (MCDBA) or equivalent modern certification
• Oracle Certified Associate (OCA) – specifically 19c, RAC, Oracle Database Appliance
• MySQL Database Administrator
General Description and Classification Standards:
As a Senior Database Administrator, you are responsible for the planning, deployment, management, and optimization of SQL Server, Oracle, and MySQL databases across both on-premise and cloud environments. This role requires in-depth knowledge of database architecture, database management best practices, and database security standards. You will support devops and production environments, ensuring system stability, performance, and data integrity. This position operates as a fully seasoned professional level within the engineering team, carrying out complex tasks with minimal supervision. Multiple incumbents in a work group may attain this level based on experience and capability.
Supervision Received:
Works under general direction with significant independence. You may take ownership of specific functions or programs and are expected to contribute expert-level knowledge to the team.
Essential Duties & Responsibilities:
Database Architecture and Design
• Design, document, and implement database architecture for on-premise and cloud systems, ensuring scalability, availability, and disaster recovery.
• Define data structures, storage, and retrieval processes, including partitioning strategies and indexing optimization.
Performance Tuning and Optimization
• Regularly monitor database performance, troubleshoot issues, and implement optimizations for SQL Server, Oracle, and MySQL environments.
• Analyze query execution plans, optimize SQL statements, and maintain efficient data retrieval and processing.
• Implement load balancing, clustering, and failover solutions.
Security and Compliance
• Ensure compliance with organizational and regulatory data protection policies by implementing best-in-class database security practices.
• Manage access controls, encryption, and auditing features to protect data integrity and security.
• Coordinate with the cybersecurity team to implement threat detection and response practices.
Backup, Recovery, and High Availability
• Develop, test, and manage backup and recovery plans for all database environments, ensuring data can be restored with minimal downtime.
• Deploy high-availability configurations using replication, mirroring, and cloud-native solutions.
Database Automation and Scripting
• Automate routine database tasks using PowerShell, Python, or SQL scripts to streamline deployments, updates, and system maintenance.
• Collaborate with the DevOps team to integrate database processes into CI/CD pipelines for automated testing and deployment.
Documentation and Training
• Maintain comprehensive documentation on database architecture, configurations, processes, and troubleshooting protocols.
• Provide training and mentoring to junior staff and contribute to the knowledge base for database management.
Cloud and Hybrid Environments
• Design and implement databases in cloud environments such as Azure and AWS, including hybrid configurations for seamless data movement and management.
• Work with cloud-based tools, including Azure SQL Database, Oracle Cloud, and MySQL on Amazon RDS, and manage database migrations to/from cloud environments.
Database Patching and Upgrade
Policy and Standards Development
• Establish and document policies and standards for regular database patching and upgrades across SQL Server, Oracle, and MySQL environments to ensure alignment with organizational security and performance requirements.
Decision Making:
• Employs best practices and organizational policies to execute tasks independently.
• Selects from multiple methods and procedures for optimal outcomes and recommends procedural changes as needed.
Leadership Provided:
• Serves as a mentor and technical resource to other team members, providing guidance on complex database issues.
• May act as a team lead on database projects and initiatives, assigning tasks and setting performance standards for database staff.
Knowledge, Skills & Abilities:
• Database Expertise: In-depth knowledge of SQL Server, Oracle, and MySQL, including experience with cloud solutions like Azure SQL, Oracle Cloud, and Amazon RDS.
• Performance Tuning and Query Optimization: Advanced skills in diagnosing and optimizing complex queries and database workloads.
• Security and Compliance: Strong understanding of database security practices, including access control, encryption, and regulatory compliance standards.
• Automation and Scripting: Proficient in scripting and automation (PowerShell, Python, SQL) for database operations and integration with DevOps workflows.
• Analytical Thinking and Problem Solving: Demonstrates critical thinking in troubleshooting complex database issues and designing resilient systems.
Data & Reporting:
Data Centralization and Warehousing
• Design, implement, and manage centralized data repositories to support data warehousing and business intelligence needs, ensuring integration across multiple database environments including SQL Server, Oracle, and MySQL.
• Develop and maintain ETL (Extract, Transform, Load) pipelines to automate data ingestion from various sources into the central data warehouse, supporting structured and unstructured data.
Data Automation and Pipeline Management
• Build and manage automated data pipelines to streamline data flow from source systems to reporting layers, including real-time and batch data processing.
• Leverage tools such as Azure Data Factory, SSIS (SQL Server Integration Services), or Oracle Data Integrator to orchestrate data movement and transformation tasks.
Data Accessibility for Reporting and Analytics
• Ensure data sources are accessible, reliable, and structured to meet the needs of data analysts, business analysts, and other end-users.
• Optimize data models and database structures to support reporting tools, including Power BI, by providing accessible datasets and views that facilitate quick insights and visualizations.
Performance Optimization and Maintenance
• Continuously monitor and enhance data pipelines and ETL processes to ensure optimal performance and reduce latency in data availability.
• Implement data archiving and partitioning strategies to manage data growth and maintain reporting efficiency.
Documentation and Compliance
• Document data flows, pipeline configurations, and reporting data models to ensure transparency, reproducibility, and adherence to data governance standards.
• Collaborate with the data governance team to maintain data quality, security, and compliance with organizational and regulatory requirements. - **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Rose International was not only attentive and responsive, but they were very professional and helpful whenever I called or needed any assistance.
Diane, Consultant
Rose International has been great to me. I thank everyone there for all of their hard work; it has not gone unnoticed.
Melody, Consultant
Rose is an assembly of people grounded in honesty, truth and dignity for all of its employees and contractors.
Samba, Consultant
Thanks for the opportunity. If in the future I ever need a job, I would like to work for Rose International.
David, Consultant
You are customer service oriented. No matter whether it was the Recruiter or someone in Human Resources/Payroll, you were responsive. That to me is key!
Tonya, Consultant
EMPLOYEE COMMENTS