Responsibility: The candidate will be responsible for -
Database Administration & Management:
Design, implement, and maintain databases.
Ensure database availability, security, and performance optimization.
Manage database backup, recovery, and failover processes.
Implement data retention and archiving strategies.
Performance Monitoring & Optimization:
Monitor database performance and optimize queries for efficiency.
Analyze system resource usage and adjust configurations for peak performance.
Troubleshoot database issues and implement corrective measures.
Data Security & Compliance:
Ensure database security and implement access controls.
Manage user roles, privileges, and authentication mechanisms.
Ensure compliance with data governance, GDPR, and industry regulations.
Backup, Recovery & Disaster Recovery:
Develop and maintain backup strategies to ensure data integrity.
Perform database recovery and disaster recovery planning/testing.
Implement high-availability and replication strategies.
Data Integration & ETL Processes:
Work with ETL tools to extract, transform, and load data from various sources.
Maintain and optimize data pipelines for efficient data flow.
Ensure data consistency and accuracy across systems.
Database Development &Automation:
Write and optimize complex SQL queries, stored procedures, and triggers.
Automate database tasks using scripting languages like PowerShell or Python.
Assist developers with database design, indexing strategies, and query tuning.
Collaboration & Documentation:
Work closely with application developers, data engineers, and business analysts.
Document database architectures, configurations, and best practices.
Provide training and support to technical teams on database best practices.
Quality Assurance & Troubleshooting:
Perform database testing and validation to ensure reliability.
Troubleshoot and resolve database-related issues in a timely manner.
Implement monitoring tools to detect anomalies and potential failures.
Requirements
Skills Required:
Educational Qualification:
Bachelor’s degree in computer science, Information Systems.
Work Experience:
At least 5 years of experience in database administration and management.
Proven experience in managing enterprise-level databases.
Professional Certifications (Preferred):
Microsoft Certified: Azure Database Administrator Associate.
AWS Certified Database – Specialty.
Technical Expertise:
Strong expertise in SQL Server, Azure DB, MySQL, PostgreSQL, or MongoDB.
Experience with database performance tuning and indexing strategies.
Proficiency in backup, recovery, and disaster recovery planning.
Knowledge of ETL tools, data warehousing, and integration frameworks.
Experience with cloud-based databases (AWS RDS, Azure SQL, Google Cloud
SQL).
Other Requirements:
Strong analytical, problem-solving, and critical-thinking skills.
Ability to manage multiple projects and stakeholders simultaneously.
Excellent communication and interpersonal skills.
Ability to identify and mitigate potential security threats.
Strong documentation and reporting skills.