Job Description

• 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