Swapna Dowlagar

Results-driven Oracle Database Administrator with a proven track record of optimizing performance and enhancing reliability at CGI Inc. Spearheaded critical projects that improved database efficiency across versions 9i to 19c. Possesses strong problem-solving abilities and extensive experience managing data on Unix and Linux platforms. Committed to leveraging technical skills to drive operational excellence and support organizational objectives.

References shall be provided upon request.

• CGI Inc., Ontario, Canada, Senior Consultant, 03/20 - Present
• Client 1 CIBC, 03/20 - 06/23: Worked on multiple minor projects for creation of 2 node RAC databases in 11g and 12c., Responsible for Installation and configured Goldengate 19c on 12c database for data replication.
• Refreshing the non-production databases from production data., Working with the backup and monitoring teams to register the databases for backups and monitoring.
• Worked on multiple NSSR request for creation of the reporting databases for CMO RPT and Prod & DR environment of version 12.1.0.2.
• Creation of new schemas, tablespaces and load the data, create services for client connectivity for 11.2.0.2 and 12.1.0.2 environments., Upgrade the Grid home and Database home from 11.2.0.2 to 11.2.0.4, in order to upgrade to 12c., Upgrade Oracle RAC enable environments with ASM from 11.2.0.2 to 11.2.0.4 in non-prod and prod & DR environments and apply the latest PSU patch., Tune all Oracle instance components including SQL and PL/SQL., Provide data migration and data extract support., Control access permissions and privileges to database users.
• Test and enable new database features and customize in order to make them fit for purpose., Install, configure and test Oracle Enterprise Manager (OEM) grid agent., Provide performance tuning and optimization of Oracle databases., Provide documentation including data standards, procedures and definitions., Monitor and ensure CPU, Memory, I/O, Storage are functioning as expected.,
• Client 2 Trade360, 03/20 - Present: Created and setup databases for SWD(Sweden) bank of version 12.1.0.2., Build the DR databases, stop and start the replication as required by the client and performed the reverse bootstrap on the databases., Use of materialized views for creation of reporting database., Worked on the TDE encryption.
• Evaluated the performance tuning of the production databases., Worked on multiple CRQs to clean up the unwanted database parameters which improved the slowness of databases.
• Performed multiple emergency and maintenance releases and worked on major application releases for the production banking databases.
• Installed & configured the POC database for the UAT environment to use it as a part of evaluating 19c version before upgradation project of all the production databases., Upgraded non-prod and prod databases from 12c to 19c version by automating the scripts., Collaborated with the team members during the releases and major upgrade activities.,
• Client 3, CSA, 03/20 - 12/23: Worked on multiple deployments of new code release to NSRPs for SIT, UAT and Stage environment.
• Installed and configured the Oracle Goldengate 19c for 12c RDBMS databases., Performed database health checks, and maintenance activities whenever needed by the apps team.
• Performed database upgrades from 12c to 19c and opened Oracle SARs on performance related issues., Worked on the data migration, data load and deployment and monitoring the performance of databases.
• Client 4, NUANS, 03/20 - 11/22: Worked on the build of the Pre-prod, Prod and DR environments., Installation of 19c Grid software, Oracle 19c Software installation and creation of Standard oracle database.
• Use of export & import procedures to load the data as and whenever needed., Participated in the meetings involved for the build and upgrade.
• Collaborated with other teams to get the work done on time., Worked on the cutover for all the environments and during the server renaming procedure.
• Client 5, CGI Corpo, 03/20 - Present Worked on various projects to create the primary database and use of RMAN to duplicate the database for standalone and RAC on the Exadata machines., Create the DR databases on the RAC environment on Exadata machines.
• Worked on automation of the scripts for migration of databases from non-Exadata to Exadata and upgrading them to 19c from 12c., Ability to provide the requested work with the stipulated timelines., Worked with the monitoring and backup teams.
• Refresh of the non-prod databases with the latest RMAN backups from Prod databases., Configured the databases as targets in the OEM 13c for the newly migrated Exadata databases.
• Ministry of Transportation of Ontario, Ontario, Canada, Database Support, 10/20 - 03/21 :
• Provided ongoing Oracle database support to project teams and to all non-production and production databases environments., Responsible for Installation and configured Goldengate 19c on 12c database for data replication.
• Involved in troubleshooting issues in Goldengate-strategy and approach, performance of Oracle Goldengate-lag and checkpoint., Refreshing the non-production databases from production data.
• Tune all Oracle instance components including SQL and PL/SQL., Provide data migration and data extract support., Control access permissions and privileges to database users., Maintain data standards, including adherence to the Data Protection Act.
• Test and enable new database features and customize in order to make them fit for purpose., Install, configure and test Oracle Enterprise Manager (OEM) grid agent.
• Provide performance tuning and optimization of Oracle databases., Provide documentation including data standards, procedures and definitions., Monitor and ensure CPU, Memory, I/O, Storage are functioning as expected.
• Collaborate with Project Manager, IT Leads, DBAs, project teams and vendors., Support deployments and releases activities.
• Canadian Business College, Ontario, Canada, Instructor, 04/18 - 10/20, Managed the databases across all the campus location., Responsible for maintenance of student information data into the databases and administering the databases., Performed backups and recovery of old student records, creation of user profiles and password., Responsible for teaching the students with the essential Unix skills to successfully perform DBA tasks., Responsible for teaching 12c Oracle affiliated training courses to the students including Multitenant, RAC, ASM, Dataguard & Oracle Goldengate administration.
• Provided real time work environment by setting up lab and assisting students during their practice sessions., Trained students on Installation of software & Database, Administration, providing working experience to the students on management tools like sqlplus, SQL developer, 12c OEM Database Express & Cloud control, configuring oracle network environments and upgrading the database to Oracle 19c.
• Provided knowledge on the DBA responsibilities of backup & recovery and helping with backup & recovery workshop., Taught concepts, create, manage Multitenant container database (CDB) and pluggable database (PDB)., Managed security, backup-recovery, in CDBs and PDBs., Taught students on Data moving methods like Oracle Datapump, SQL
• Loader, expdp & impdp and to perform regular database maintenance task and managing performance planning & monitoring activities., Provided knowledge to the students about the importance of upgrades and different methods of upgrades using manual & DBUA and guiding the students to perform migration to 19c databases.
• Trained students on Administering Microsoft SQL server databases., Provided multiple tasks and assignments to students and responsible for evaluating in their presence., Encouraged students to get Oracle certified and supporting them in their preparations.
• Tata Consultancy Services, Hyderabad, India, Database Administrator, 05/16 - 04/17 :
• Responsible for user management activities, data refresh using oracle data pump & exp/imp utilities., Monitored and acted on On-call alerts and support., Managed & maintained Exadata and non Exadata database operations., Refreshed Oracle databases periodically from production to lower environment for testing purposes using RMAN., Migrated DBs from 10gR2 and 11gR2 on Solaris to 12c and worked on the upgrade of databases from 11g to 12c database using DBUA., Experience in Real Application Cluster (RAC) with Automatic Storage Management (ASM) and manage RAC instances using CRSCTL and SRVCTL Utility., Extensively worked with ASMCMD for managing ASM., Patch Management and version upgrades (PSU / CPU /Bug Patches on Single node / RAC nodes db)., Proactively monitored the performance of databases through OEM and resolving the performance issues., Creating standby database and configuring data guard broker using DGMGRL., Installed and configured Oracle EM Grid Control 12C to monitor Exadata and other Oracle prod databases., Installed and configured 12c databases on Linux/Unix servers., Monitored health of the databases by monitoring alert logs, operating system file system space usage and trace files., Analyzed root causes and implemented recommendations to prevent recurring problems and incidents., Troubleshot the RAC availability issues., Performed data loads with SQL- loader using data pump and export/import utilities., Automated daily routine tasks, including user management, daily hot backup and weekly cold backup using CRON, storage management.
• Configured RMAN backups and recovering the databases upon request., Ran Oracle provided diagnostics (RDA) to identify and solve the problems., Responsible for gathering the client requirements and handling the junior team members.
• Monitored various database activities such as backups, error logs, space, object, performance and user and session monitoring to ensure proper capacity and availability., Monitored the availability of system, listener, database, alert log file, trace file.
• Tech Mahindra, Hyderabad,Pune, India, Database Administrator, 06/12 - 05/16,
• Client 1, GE Healthcare TSO Operations, 07/15 - 05/16, Provided L2 and L3 Production support including processing the emails, monitoring all the alerts and acting on On-call alerts., Managed and supported 150+ databases providing 24
• 7 support., Proactively monitored the performance of databases through OEM and resolving the performance issues., Monitored the SQL queries and tuning the queries using Tuning advisor.
• Supported maintenance and development team with all the Database Operational tasks., Refreshing and Cloning Dev/Stg database from Production databases using RMAN., Implemented and maintained database security (create and maintain users, roles and assign privileges)., Performed import/export of users and created database users, users access control/profiles/roles and tablespace quotas., Performed online and offline backup and partial/complete recovery, using both GUI/command line syntax and using Recovery Manager (RMAN)., Planned and assisted with impact analysis of any changes made to database objects and be part of change control process.
• Database defragmentation using different methodologies to reclaim space., Monitored system resource usage (disk, memory, CPU, IO) in conjunction with System Administrators group., Monitored the DR databases and configure standby databases.
• Worked with storage team for LUNs allocation and ASM disk group administration., Provided off hours support, and part of the on-call rotation as required.
• Client 2, GE Capital Treasury, 08/14 - 07/15, Supported over 750+ Production and non-prod databases in 27 environments., Maintained databases, implemented the Service Request and Change Request that may come up., Looked into the database performance issues.
• Participated in the scheduled DR Activity., Scheduled refreshes for database, schemas, tables using export, import, data pump and RMAN utilities for requested applications.
• Collaborated with application administrators for migration, upgrades and patching., Performed Oracle software installation, database creations, upgrade database, apply CPU and PSU Patches as required., Day to day activity for space and backup monitoring.
• Supported Load test team during release by checking Top SQL, SQL monitoring using OEM and help optimise them., Participated in disaster recovery exercises.
• Extensively used OEM 12c to monitor the health and performance of databases., Configured RMAN backup, scheduling CRONS for backup as per application requirement., Bound to the Service Level Agreements (SLA)., Exposure to databases on ZFS storage environment., Setup and maintain documented SOPs., Knowledge building activities for teammates and fresher joining the team., Hands on experience in installation and maintenance of databases in RAC environment., AT&T, 06/12 - 08/14, Worked in ODBA team as Backup DBA supporting 1500+ databases in 24*7 environments., Performed Oracle Software Installation, Database Creation, upgrade database, apply CPU, PSU, and Interim Patches as required and installed OEM Agent, Security package, Patrol., Day to day activity for space and backup monitoring., Performed database cloning to setup test and development database., Creating and maintaining user Schemas., Configuring RMAN backup, scheduling crons for backup as per application requirement., Periodic database analysis for tuning using OEM, Patrol, Sitescope.
• Client interaction and planning of activities., Ensuring that storage, archiving backup and recovery procedures are functioning correctly., Built the Service Level Agreement (SLA) and associated application alert set up with all stakeholders., Ensured proper procedures and processes are maintained.