Senior Database Administrator DBA
Senior Database Administrator DBA
Posted on :
04-12-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
04-12-2024
Job Description
Client: City of Atlanta/ATL AIM Aviation Services
Job ID: 63701
Job Title: Senior Database Administrator (DBA)
Pay rate: $40/hr on C2C
Location: 6000 North Terminal Pkwy Atlanta Georgia 30320
Estimated Duration: 12/01/2024 06/30/2025
Onsite Must be local to GA
Description
Job Class Specification: Senior Database Administrator (DBA)
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 onpremise and cloud environments. This role requires indepth 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 expertlevel knowledge to the team.
Essential Duties & Responsibilities:
Database Architecture and Design
- Design document and implement database architecture for onpremise 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 bestinclass 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 highavailability configurations using replication mirroring and cloudnative 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 cloudbased 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: Indepth 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 realtime 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 endusers.
- 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.
Minimum Qualifications Education and Experience:
- Bachelors 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:
- Masters degree in Computer Science Information Systems or a related discipline.
- 8 years of direct experience in database administration across onpremise 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
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
