Job Description:
Experience: Minimum 7 yrs
Location: Client office in Delhi. Remote working options are not available.
We are seeking an experienced Database Administrator (DBA) with at least 7 years of experience to join our Data Analytics team, which focuses on developing real-time dashboards for critical government projects. The DBA will play a key role in managing and optimizing databases, ensuring efficient data storage, retrieval, and security, while supporting the integration of multiple data sources into a centralized analytics platform.
The ideal candidate will have extensive experience in database management, performance tuning, and ensuring high availability and security of data systems. They will work closely with data engineers, analysts, and developers to ensure smooth data flow and integration for dashboarding and reporting.
Key Responsibilities:
•Database Management and Maintenance
o Design, deploy, and maintain scalable, high-performance relational and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB) to support the data analytics platform.
o Perform regular database maintenance, including backups, indexing, defragmentation, and optimizing storage and retrieval processes.
o Ensure the database environment is up-to-date with security patches, software upgrades, and regular performance audits.
•Data Security and Backup
o Implement robust security protocols to safeguard sensitive data, including encryption at rest and in transit, multi-factor authentication (MFA), and access control mechanisms.
o Set up and manage database backup strategies to ensure data is securely backed up, with regular restoration tests for disaster recovery.
•Performance Optimization and Tuning
o Optimize the performance of database systems through query tuning, database indexing, partitioning, and storage optimization to ensure fast and reliable access to data.
o Identify and resolve database performance bottlenecks, troubleshoot slow queries, and improve data retrieval times for the dashboards.
o Monitor database performance metrics, such as response time, query efficiency, and system resource usage, using appropriate database monitoring tools.
•Data Access Control and Permissions
o Implement role-based access control (RBAC) to manage and restrict data access based on user roles and responsibilities.
o Maintain a strict policy for managing user permissions, ensuring that only authorized personnel can access sensitive data.
o Regularly audit database access logs to detect and prevent any unauthorized access or suspicious activity.
•Database Scalability and Capacity Planning
o Collaborate with data engineers and developers to design databases that can scale horizontally and vertically to accommodate increasing data volumes and user loads.
o Plan and manage database capacity, ensuring storage and processing capabilities grow with project requirements.
o Continuously evaluate database storage needs and implement strategies to ensure optimal use of resources, both in on-premise and cloud environments.
Data Integration and ETL Support
o Work closely with data engineers to ensure seamless data integration from multiple sources into the centralized data platform.
o Support Extract, Transform, Load (ETL) processes, ensuring that data is correctly ingested, transformed, and stored in a manner suitable for analytics and reporting.
o Troubleshoot any issues related to data synchronization, data transformation, or inconsistent data across the system.
• Monitoring and Troubleshooting
o Implement and manage database monitoring tools (e.g., SolarWinds, Oracle Enterprise Manager) to track database health, performance, and security in real-time.
o Troubleshoot database issues, such as connectivity problems, data corruption, or system outages, ensuring minimal downtime for the dashboard team.
o Proactively identify potential issues before they escalate, using automated alerts and early-warning systems.
Required Skills & Qualifications:
•Education: Bachelor’s degree in Computer Science, Information Technology, Database Management, or a related field. A Master’s degree or relevant certifications (e.g., Oracle DBA, Microsoft SQL Server DBA) is preferred.
•Experience: At least 7 years of hands-on experience as a DBA, with a focus on managing databases in data analytics or dashboard environments.