SQL Database Administrator

As a Database Administrator, your responsibilities will include: - 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. - 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). - Troubleshooting and resolving database problems. - Implementing and maintaining database security by creating and maintaining users and roles, as well as assigning privileges. - Monitoring database growth and health, including Capacity Planning. - Setting up Test, Dev, Staging, and Production Environments of SQL Server. - Indexes, Fragmentation, and other DB Maintenance and Optimizations tasks. - Building efficient and maintainable queries, stored procedures, etc. that meet business needs. - Taking care of Database design and implementation, building tables, FKs, PKs, etc. - Providing consultation to development teams and performing general technical troubleshooting. - Establishing and maintaining sound backup and recovery policies and procedures. - Maintaining documentation and standards of Database architecture. - Collaborating with business analysts to understand business requirements. - Experience 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 restrictions. - Experience in NoSQL database & cloud technologies like AWS, Big Data are added advantages. - Experience in financial markets is an added advantage. As part of DBA Activities, your role will involve: - Maintaining the server and ensuring its smooth operation, including backups, security, patches, and replication. - Building queries, stored procedures, etc. to meet business needs, primarily using T-SQL. - Designing schemas, building tables, FKs, PKs, etc. to align with business requirements. - Merging data from multiple sources into a data warehouse, including cleaning, standardizing, and scrubbing data before loading. As a Database Administrator, your responsibilities will include: - 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. - 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). - Troubleshooting and resolving database problems. - Implementing and maintaining database security by creating and maintaining users and roles, as well as assigning privileges. - Monitoring database growth and health, including Capacity Planning. - Setting up Test, Dev, Staging, and Production Environments of SQL Server. - Indexes, Fragmentation, and other DB Maintenance and Optimizations tasks. - Building efficient and maintainable queries, stored procedures, etc. that meet business needs. - Taking care of Database design and implementation, building tables, FKs, PKs, etc. - Providing consultation to development teams and performing general technical troubleshooting. - Establishing and maintaining sound backup and recovery policies and procedures. - Maintaining documentation and standards of Database architecture. - Collaborating with business analysts to understand business requirements. - Experience 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 restrictions. - Experience in NoSQL database & cloud technologies like AWS, Big Data are added advantages. - Experience in financial markets is an added advantage. As part of DBA Activities, your role will involve: - Maintaining the server and ensuring its smooth operation, including backups, security, patches, and replication. - Building queries, stored procedures, etc. to meet business needs, primarily using T-SQL. - Designing schemas, building tables, FKs, PKs, etc. to align with business requirements. - Merging data from multiple sources into a data warehouse, including cleaning, standardizing, and scrubbing data before loading.