Database Administrator

Job description

Job Description:

As a Database Administrator (DBA), you will be responsible for managing and maintaining the organization's database systems to ensure their performance, availability, and security. You will work closely with other IT professionals, including system administrators, developers, and data analysts, to design, implement, and optimize database solutions that meet the organization's needs.

Key Responsibilities:

• Database Design and Implementation: Design and implement database solutions based on the organization's requirements, considering factors such as data volume, performance, and security. Create and modify database schemas, tables, views, and other database objects.

• Database Performance Optimization: Monitor and optimize the performance of database systems, including identifying and resolving performance bottlenecks, tuning SQL queries, and configuring database parameters.

• Database Queries/Procs : Helping team to write complex queries , procedures and user defined functions, must have ability to optimize the performance of queries.

• Database Security: Implement and maintain database security measures, such as user authentication and authorization, data encryption, and database auditing. Monitor and address database security vulnerabilities and incidents.

• Database Backup and Recovery: Develop and implement database backup and recovery strategies to ensure data integrity and availability. Perform database backups, restores, and disaster recovery procedures.

• Database Monitoring and Troubleshooting: Monitor database systems to proactively identify and resolve issues, such as database errors, performance degradation, and data inconsistencies. Investigate and troubleshoot database-related incidents and provide timely resolution.

• Database Maintenance: Plan and execute database maintenance tasks, such as database upgrades, patching, and database reorganizations. Apply database patches and upgrades as needed, and ensure database systems are running on supported versions.

• Database Documentation and Reporting: Maintain accurate and up-to-date documentation of database systems, including database design, configuration, and operational procedures. Generate reports on database performance, capacity, and availability for management and other stakeholders.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field.


• Proven experience with minimum 4 year of experience as Database Administrator, managing and maintaining database systems.


• Strong understanding of relational database concepts, database design principles, and data modeling.


• Proficiency in SQL and experience with database management systems such as Microsoft SQL Server, MySQL, or PostgreSQL along with NoSQL like MongoDB and Cloud Databases.


• Knowledge of database performance tuning techniques, backup and recovery strategies, and database security best practices.


• Experience with database monitoring and troubleshooting tools.


• Familiarity with scripting languages, such as Python or PowerShell, for automating database tasks is a plus.


• Excellent problem-solving skills, attention to detail, and ability to work independently or as part of a team.


• Strong communication and interpersonal skills to collaborate with cross-functional teams and communicate effectively with technical and non-technical stakeholders.