SQL Database Administrator

Main Purpose

A SQL Database Administrator (DBA) plays a critical role in managing and maintaining the organization’s relation database systems. The primary responsibility of the individual is to ensure the performance, security, and availability of the SQL databases, enabling seamless data access and retrieval for the organisations’ applications and users. This role requires a strong understanding of database management principles and technologies, SQL language proficiency, and expertise in database administration tools and practices. An SQL DBA plays a critical role in ensuring that the organisation’s database systems operate smoothly, securely, and efficiently. The individual is essential for maintaining data integrity, enabling data-driven decision-making, and supporting the performance of applications that rely on these databases.

A skilled SQL DBA can help prevent data loss, minimize downtime, and optimize database performance, ultimately contributing to the overall success of an organization.

Roles and Responsibilities

• Install, configure, and upgrade SQL database management systems and implementation of best practices for database server setup and configuration
• Optimizing database performance by monitoring and fine-tuning SQL queries, indexing, and other database components to ensure efficient data retrieval
• Implementation and maintenance of database security measures, including user access controls, encryption, and auditing, to protect sensitive data
• Applying patches and updates to keep the database software current, reducing vulnerabilities and ensuring stability
• Maintaining comprehensive documentation of database configurations, processes, and procedures is crucial for future reference and compliance
• Establish and execute data backup and recovery procedures to ensure data integrity and availability, including disaster recovery plans.
• Collaborate with developers, system administrators, and other teams to meet database requirements and provide technical support.
• Maintain a knowledge repository of emerging technology and industry best practices trends, pursue relevant certifications, and expand technical capabilities to match evolving organisational needs.
• Monitoring of database growth trends and plan for scalability by assessing hardware requirements and making recommendations
• Assisting in data migration projects, ensuring data is moved accurately and efficiently between systems.

Competencies and Minimum Requirements:

Knowledge

• Sound knowledge of relational and non-relational database systems like MS SQL, MySQL, Oracle, MongoDB, etc., and their specific features.
• Strong command of SQL language for querying and database manipulation.
• Ability to design efficient and normalized database schemas, including defining tables, relationships, indexes, and constraints
• Skills in optimising SQL queries and database performance by analyzing query execution plans, indexing strategies, and database configuration.
• Understanding of how stored procedures, user-defined functions, and triggers work to encapsulate business logic within the database.
• Familiarity with cloud services like AWS, Azure, or Google Cloud and their interactions with data operations.
• Familiarity with data analytics and reporting tools such as Tableau, Power BI, etc.
• Understanding of the business domain and how data supports and enhances business operations
• Continuous updating of knowledge related to emerging trends in data operations and technology.

Qualification

• A Btech or bachelor's in a relevant field, such as Computer Science, Information Technology, or a related discipline.
• Demonstrates a foundational understanding of IT service management
• Cloud and/or on-premises certification in SQL Server administration

Experience:

• 5-7 years of Hands-on experience in designing, managing, and optimizing both relational and/or NoSQL databases. Experience in backup and recovery processes and disaster recovery planning.
• Skills in optimizing SQL queries and database performance by analyzing query execution plans, indexing strategies, and database configuration
• Demonstrate competency in SQL server auditing, access control, and role membership. Database encryption methods
• 5 -7 years of experience with SQL Server Reporting Services and SQL Server Analysis Services
• 3 years of experience in data virtualization tools like Tableau, Power BI, Business Objects
• Knowledge of ETL (Extract, Transform, Load) processes to integrate data from various sources into a centralized database system