Shitij (Polly) Chatwal

Twenty Years of experience in World's TOP 5 Global Multinational Corporation including IBM, Oracle, EDS, HP, Equifax. Extensive expertise in SQL Server and Oracle Database administration, upgrades, migrations, and cloud platform implementations. Expert in building and managing high availability solutions, performing data center migrations, and leading database infrastructure projects.

Strong background in project management, ITIL standards, and customer engagement with proven ability to manage large-scale database environments across multiple platforms and operating systems.

Senior Database Administrator - MGA

(2023-03)

• Perform Daily check and health check for all MGA Oracle customers.
• Perform successful upgrade of Oracle 11g and 12c Oracle database to Oracle 19c on Red Hat Linux servers.
• Written shell scripts for RMAN backups and configured mails for successful backups.
• Build PostgreSQL Database environment. Configured streaming replication, EDB Failover manager, Barman and PEM for MGA customers.

Senior Database Consultant - MobulutionIT

(2022-09 - 2022-11)

Client: DataServ

• Installing, Configuring and Maintenance of SQL Server database for Dev/Test/Pre Production and Production database.
• Configured Log shipping for all mission critical Production SQL Server database instances.
• Build Always on high availability group for mission critical production SQL Server databases.
• Automated SQL Server database backups, database integrity, index rebuild/reorganise, update statistics via maintenance plans.
• Perform Performance tuning for all mission critical databases and created clustered, non clustered and covering indexes for poorly performing queries.

Senior Database Consultant - Lyra Infosystems

(2021-10 - 2022-09)

Client: Enterprisedb

• Responsible for Installation of Enterprisedb Advanced Server and migration of Oracle Databases to Enterprisedb Advanced Server for over 5000 Clients of Enterprisedb across the Globe.
• Writing Backup and Maintenance scripts for Postgres databases for various clients of Enterprisedb using pg_dump, ph_dumpall, vacuum full, vacuumdb, reindexing etc.
• Successfully performed deployments of Postgres, Replication, EDB Failover manager, Barman and PEM for EDB customers such as Digital Payments, Central Bank of Qatar, STC Pay, Satlicom etc.
• Monitoring of various database for Enterprisedb Customers.

SQL Server, Azure SQL Database Administrator, Oracle Database Administrator, DB2 LUW DBA and Postgres DBA - Independent

(2019-02 - 2021-09)

• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration.
• Migrated SQL server 2008 and SQL Server 2012 to SQL Server 2014 on Microsoft Windows Server 2012 Standard Edition using Side by Side Migration and Upgraded SQL Server 2012 databases to SQL Server 2014 on Microsoft Windows Server 2012 Standard Edition using IN-Place Upgrade.
• Installed and administered Two-Node cluster Active/Passive on Microsoft Windows Server 2012 Standard Edition on SAN environment.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Performed DR Drill by Performing Switchover from Standby database to Primary Database and Failover from Primary Database Server to Standby Database Server.
• Applied PSU (Patch Set update) to Oracle 12.1.0.2 RAC Grid Infrastructure and Oracle Database Home using Opatch.
• Responsible for RMAN backups of production databases.
• Migrated 1500 SQL Server On Premises Databases to Microsoft Azure SQL Databases and Azure Managed Instance using SSMS Deploy database to Azure SQL using Data Migration Assistant and Backup and restore method. Created Elastic pools for various Azure SQL Databases for effective resource utilisation.
• Migrated and Upgraded databases from 11gR2 to 12cR1 and 19c.
• Refreshed Test and Development Databases from Production Databases for Development Team.
• Installed, Configured and Maintained PostgreSQL Databases for Dev/Test/Production Environment. Wrote Backup and Maintenance scripts for PostgesSQL Databases using pg_dump, pg_dumpall commands.
• Regularly Analysing tables using Analyze commands in PostgresSQL for choosing optimal plans by the optimiser during execution phase of the query.
• Installation and configuration of DB2 10.1/10.5 and upgrading from 10.5 to 11.5 database servers.
• Maintenance of DB2 servers via reorg and runstats and automated backups of DB2 Prod, UAT and Dev database servers via shell scripts.

Technical Consultant - Smart Vision Solutions Private Limited

(2018-07 - 2019-01)

• Technically Evaluating Potential Candidates and providing feedback to the Management.
• Providing SQL Server and Oracle Technical Solutions to various clients of Power IT Services.
• Evaluating Current SQL Server Infrastructure of PowerIT Services and building High Availability Solutions such as Failover Clustering, Always On High Availability Groups for Critical Production databases and offloading Backups on Secondary Replicas (Databases) in Synchronous mode and Reporting on another Secondary Replica in Asynchronous mode.
• Build Snapshot databases for QA/Testing Environment in SQL Server Enterprise Edition.
• Refresh of Databases on Adhoc basis for Development Team.
• Installation and configuration of DB2 10.1/10.5 and upgrading from 9.7 to 10.5 database servers.
• Maintenance of DB2 servers via reorg and runstats and automated backups of DB2 Prod, UAT and Dev database servers via shell scripts.

Database System Engineer (SQL Server DBA) - Attribute Consulting - North Sydney

(2017-09 - 2018-05)

Client: Equifax

• Installed SQL Server 2016 SP1 CU4 and Upgraded 3000 Production/QA/DEV Databases of SQL Server with 15 SQL Server Database Instances running on each Upgraded Server and more than 5 Terabytes database with 800 GB Memory from SQL Server 2012 SP2 to SQL Server 2016 SP1 CU4 using IN-Place and Side by Side Migration.
• The configuration and settings of new SQL Server 2016 Cluster EE x64 and Standalone SQL Server 2016 EE x64 servers for the migration project.
• The planning, design, and implementation of upgrade from SQL Server 2008/2012/2014 to SQL Server 2016 EE x64.
• The migration and configuration of SQL high availability strategies such as Log Shipping, Transactional Replication, SQL Failover Clustering and Always On from SQL Server 2008/2012/2014 to SQL Server 2016 EE x64.
• The migration of SQL Server Users, Databases, JOBs, Alerts, Linked Servers, Database Mail, Database Maintenance Plan, SQL Audit, etc to SQL Server 2016 EE x64.
• The migration and upgrade of SQL Server Integration Services (SSIS) Packages from 2008/2012/2014 to SQL Server 2016 EE x64.
• The migration and upgrade of SQL Server Reporting Services (SSRS) Reports from 2008/2012/2014 to SQL Server 2016 EE x64. Migrate SQL Server Reporting Services to new version of SQL Server 2016 Reporting Services.
• The migration and upgrade of SQL Server Analysis Services (SSAS) from 2008/2012/2014 to SQL Server 2016 EE x64.
• The migration of different Applications configured under SQL Server 2005/2008/2012/2014 to SQL Server 2016 EE x64.
• The preparation of the Migration Plan Document and the Architecture Plan Document.
• Liaise with Managers, Project Managers, Application Owners, Analysts, Developers, DBAs, and End-Users to discuss the new requirements and new proposals

Master of Business Systems (Information Technology) - Information Technology - Monash University (2000-01 - 2001-01)

Bachelor of Commerce - Commerce - University of Delhi (1996-01 - 1999-01)