Shahid K.

Database Administrator expert(Postgres,MySQL,MSSQL,AWS)

• 15+ years of IT experience & over 12 years of extensive experience as Oracle, PostgreSQL, MS SQL Server, Azure SQL, MySQL, MongoDB, MariaDB, AWS Database Administrator, providing 24X7 production and development support on different platforms like Oracle Exadata, HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows. • Experience in Performance Tuning such as tuning of memory, CPU, I/O distribution, shared memory segments using utilities like Explain Plan, Stats pack, OEM, AWR, ADDM, ASM, TKPROF. performing health and performance check of database by identifying bottlenecks affecting Oracle system using PL/SQL. • Excellent Backups and Recovery skills that involve logical backups (Import / Export), Hot/Cold Backup and tools and utilities like RMAN, pgbackrest, barman, Customized Scripts, Import/ Export and Verities Net • Implementation of high availability solutions with Oracle 10g/11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, Golden Gate. • Configuring PostgreSQL streaming replication and pgbouncer for load balancing. Monitoring tools like pgbadger, pgadmin, Graphana, DBeaver. • Excellent SQL skills including query optimization and business analytical reporting. • Experience in upgrading and migrating various versions of PostgreSQL databases on different platforms. SQL Server & Azure Data Platform Management • Administered, tuned, and maintained a large fleet of on-premises and Azure SQL databases, ensuring 24/7 availability and performance for high-throughput claims platforms.