SQL Database Administrator

March 19, 2024

Responsibilities:

Installation, configuration and upgrading of Microsoft SQL Server / MySQL software and related products.

Experience with Database Administration for MSSQL Server versions 2008, 2012 and 2016 with a strong understanding of database structure

Experience in Performance Tuning, Application tuning and Optimization (PTO), using monitoring and troubleshooting tools for SQL Server

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server (Failover Clustering, Database Mirroring, Log Shipping and Replication)

Experience in troubleshooting and resolving database problems

Implement and maintain database security (create and maintain users and roles, assign privileges).

Monitors database growth and monitor the health of the database (Capacity Planning).

Experience in Setting up Test, Dev, Staging and Production Environments of SQL Server

Knowledge of Indexes, Fragmentation, and other DB Maintenance and Optimizations tasks

Experience in building efficient and maintainable queries, stored procedures, etc. that meet business needs.

Take care of the Database design and implementation, building tables, FKs, PKs, etc. Work to build a structure that meets the business needs in general.

Do general technical troubleshooting and give consultation to development teams.

Installation, configuration, and upgrading of Microsoft SQL Server/MySQL/NoSQL software and related products.

Establish and maintain sound backup and recovery policies and procedures.

Maintain documentation and standards of Database architecture.

Work with business analysts, to understand business requirements

Experiences in Business Intelligence tools like SSAS, SSIS & SSRS for analysis and reporting

Providing necessary SQL reporting tools to the business team for data analysis with restriction

Experience in NoSQL database & cloud technologies like AWS, Big Data are added advantage

Experience in financial markets are added advantage

DBA Activities:

Maintaining the server and keeping it running. Concerned with backups, security, patches, replication, etc. Things that concern the actual server software.

Building queries, stored procedures, etc. that meet business needs. This is the equivalent of the programmer. You primarily write T-SQL.

Design schemas. Build tables, FKs, PKs, etc. Work to build a structure that meets the business needs in general. The design is then used by developers and development DBAs to implement the actual application.

Responsible for merging data from multiple sources into a data warehouse. May have to design warehouse, but cleans, standardizes, and scrubs data before loading .