SQL Database Administrator

Job Description: SQL Database Administrator

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