SQL server pathing on single instance and cluster environments.
Expert level skills in Backup and restore database operations and executing SSIS packages
Monitoring SQL server performance using SQL Profiler, INDEX tuning wizard and performance monitor.
Replication, Always on availability groups and clustering
Experience working in Active/Passive. Active/active cluster environment.
Implementation of SQL Server security and Object permissions like maintaining creation of users (Windows and SQL), configuring permissions, and assigning roles to users.
Migrate on -prem SQL server database to Microsoft Azure hosted DB’s.
Managed instances, High availability, always on, Log shipping, patching, Troubleshooting and optimization.
Link server create from On-prem to Azure cloud.
Configure geo replications for High availability.
Design databases to support business applications, ensuring system scalability, security, performance, and reliability
Plan and provide guidance to administrator regarding frequency of necessary upgrades to enhance database performance
Monitor and interpret systems resource consumption trends to ensure production systems meet availability requirements and hardware enhancements are scheduled appropriately
Create and enforce database development standards, preventing and correcting any deviations from database development standards
Excellent problem solving, time management, communications, and presentation skills
Excellent consulting, analytical and communications skills
Strong communication and organizing skills, and proven ability to interact and influence other technical leaders/architects in a collaborative fashion
Experience in software development with demonstrated experience in scalable data architectures and design
Problem solving / analytical skills, tools, and techniques
Experience working in a Cloud based environment. Specifically, with Azure
Experience in monitoring and tuning a database to provide a high availability service
Experience working in Windows Server environments including Windows 2016/2019/2022
Strong Windows systems, clustering and scripting proficiency
Good understanding of Distributed Systems and Parallel Processing architecture
Experience with Database Security solutions and implementations (Data Masking, Database activity monitoring, Data Encryption)
Experience delivering data warehouse/marts from specification through end-user acceptance testing
Experience with database replication, hot stand-by, clustering, and table partitioning on -prem and cloud
PostgreSQL Administration
Administer PostgreSQL databases in on-premises Linux/Windows environments and Microsoft Azure, including Azure Database for PostgreSQL - Flexible Server and PostgreSQL hosted on Azure VMs.
Install, configure, patch, and upgrade PostgreSQL instances; perform minor-version maintenance and plan major-version upgrades using suitable in-place or logical migration methods.
Manage databases, schemas, roles, privileges, authentication, pg_hba.conf, SSL/TLS, parameter configuration, extensions, tablespaces, and connection settings.
Configure automated backups, backup-retention periods, manual snapshots, point-in-time recovery, geo-restore, cross-region snapshot copies, and backup-recovery validation.
Configure and support physical streaming replication, read replicas, synchronous/asynchronous replication, replication slots, WAL archiving, and failover solutions such as Patroni, repmgr, or approved enterprise tooling.