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