SUMMARY:

• Oracle/PostgreSQL/SQL server Database Administrator wif 8 years of hands - on experience and noledge in RDBMS’s including Installation.
• Worked on Oracle 10g, 11g, 12c, 18c, 19c and postgresSQL9.6 to 12 and sql server 2012-2017 versions involving database designing and capacity planning, production support (SDLC), configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
• Adept at Glodengate, Dataguard, RAC, Exadata, EBS, OEM 12C and 13C, data warehousing, Partitioning, Shell Scripting, Microsoft SQL server.
• Very proactive and pay great attention to details, excellent communication and documentation skills, fast learner and provide support to incoming Jr. DBA’s and bring lots of positivity to my team members.

PROFESSIONAL EXPERIENCE:

Confidential Tampa, FL

Senior Database Administrator

Responsibilities:

• Experience wif relational Databases - configuration, maintenance, database and SQL tuning, backups, disaster recovery, patching, database, and file system space management.
• Ability to solve problems, quickly and completely and to communicate them clearly to peers and customers.
• Provided 24x7 production and application support troubleshooting and resolving various production issues and tickets.
• Proficient at database performance fine tuning and optimizing poorly performing queries, stored procedures.
• Performed SQL Server Application development (.NET, SSAS/SSIS/SSRS, Visual Basic).
• Strong functional noledge of T-SQL and expert noledge in Backup, design, and suppor t sql server databases.
• Work closely wif developers to deploy program and configuration changes to SQL Server production environment.
• Extensive experience wif relational databases wif a focus on MS SQL Server.
• Extensive noledge of High Availability, Disaster Recovery options and replication for SQL Server wif sql server always on failover cluster instances and availability groups.
• Experience wif DR implementation, clustered environments, database mirroring, replication, and log shipping. Analyze database performance, review SQL Server performance reports, and provide tuning recommendations
• Establish, document, and maintain standards for database infrastructure, monitoring, maintenance, and security.
• Experienced wif Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Gloden Gate and worked wif conventional EXP/IMP for migrating data from 11g to 12c.
• Has Years of experience working on SQL SERVER databases, creating databases, backups/recovery, security, refreshes, and availability solutions (MIRRORING, LOG SHIPPING, Window Failover Cluster Server. Hands on experience on SSMS, SSRS, SSIS, SSAS for reporting, integration, and analysis respectively as well as working on SQL server availability solutions in enterprise edition.
• Performed a variety of database administration functions (including installation of database software, modification of database servers, account set-up, maintenance, DB patches and upgrades) in order to support project demands.
• Tuned extensively using Toad and OEM to detect long running queries, blocking sessions, input/output, optimizer statistics and database statistics and also to detect fragmented and broken objects.
• Also tuned using dynamic performance views and dba views for diagnosis and problem resolution and also used materialized views for faster access of data and constantly refreshing the materialize views to get up to date stats.
• Created server generated alert in shell scripts and enterprise manager to monitor space usage/consumption in tablespaces and give me alerts when space is running out.
• Tuned extensively wif developers to rebuild indexes and PLSQL packages and procedures to fix Sql queries and broken objects in the database.
• Proficient at data modeling working wif clients as a logical data modeler to design the data model to fit business requirements and also to create and maintain the lookup data to compare the versions of data model, maintain change logs and generate reports from data models.
• Expert in implementing physical data models to create models from existing databases and to tune the data models wif referential integrity, alternate keys, indexes, and how to match indexes to sql codes extensively using the Erwin data modeling tool.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN wif VERITAS Net Backup and Comm vault, database vault for privilege management and database security and auditing purpose.
• Strong backup & recovery expertise using RMAN, Data pump, Snap, and Clones
• Experience wif Oracle database build using ASM / NSF on RAC/Non-RAC.
• Extensive experience wif features such as Oracle Real Application Clusters (RAC), ASM and Active Data Guard for HA and DR solutions .
• Installed and set up High Availability Oracle Gloden Gate (OGG) systems on Oracle 11g and 12c environments. Upgraded Oracle Gloden Gate (OGG) systems from 11g to 12c for replication of schemas and some very important tables.
• Experience in performance tuning, debugging, RMAN, Oracle Dataguard and Glodengate .
• Successfully performed a disaster recovery testing in my environment in March by successfully Switching over to our standby location and able to connect clients and end users to that standby site a project which alongside other successes landed me employee of the month.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
• Data warehouse specialist and very comfortable managing large databases ranging from 500mb-5TB. Adept wif ETL processes using tools like Informatica, ab initio and Talend.
• Implemented Partitioning on huge tables to improve the performance and reduce the maintenance to finite window operations by adding new partitions, exchanging year old partitions tan archiving of the exchanged partitions, dropping, or truncating of old portions.
• Pro-actively monitor the performance of development and production databases to detect existing or potential incidents and/or performance issues. Perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation. Ensure operation of database environments meet or exceed agreed upon service levels (e.g., availability and performance)
• Played a very important role in the configuration of a 2 node RAC in my environment and later Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services and scaled up or down both the nodes and Disk whenever need arose.
• Involvement in timely Database and Application releases for Oracle applications. Interacting wif the Development team, Application Team, System Administrators and Release Teams.
• Generated scripts best for migration regular databases to Oracle Exadata and also migrated data from lower environments to production environment and vice versa during database refreshes.
• Has implemented and setup the Oracle Exadata machine for the client by plugging in the InfiniBand switches and ethernet network cables into the machine and set it up using OEM 13c creating a default database during setup so it can be used almost immediately.
• Used the write-back cache to leverage the Exadata flash hardware…in making the Exadata database machine faster for our Oracle Database Deployment. I also migrated our databases supporting both OLTP and OLAP workload to a new X5 database machine.
• Regularly applied PSU patches on Exadata in rolling fashion on different compute nodes using the nohup command so transactions can run in the background while patching is taking place.
• Created the new 12.1.0.2 Exadata based database…And exported the source system metadata using the Transportable tablespace…And later transferred the files to the database machine and use the RMAN CONVERT command to change them to the little-endian format.
• Managing PostgreSQL on AWS RDS and Ec2 instances creating snapshots for backup, modifying volume sizes for Ec2, modifying instances types as per batch jobs and performance, query optimization, generating AMI to setup dev and test environments, enforcing security via inbound rules and server security certs. Configuring a centralized user management system to manage passwords across many production servers.
• PostgreSQL Installation, configuration, Migration from oracle to PostgreSQL. Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks
• Performed a point in time recovery in PostgreSQL create database users and autanticated them granting tan only necessary privileges. Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases and optimized postgreSQL.conf for performance. Installed, configured, and managed PostgreSQL servers and worked recently wif PostgreSQL Version 10.x, 11.x and 12.x Community and Enterprise editions.
• Used the Enterprise DB Migration Toolkit (MTK), Ora2pg, AWS Data Migration Service (DMS) & Schema Conversion Tool (SCT) to Migrate data/databases across different database engines (Oracle to PostgreSQL) on-premises and AWS cloud using IAM, RDS, EC2 instances in AWS cloud to host our databases.
• Configured and proactively managed Streaming Replication (including cascading replication) between Master and two slaves on a PostgreSQL Server for disaster recovery, high availability and load balancing solutions.
• Monitored and tuned PostgreSQL servers using PgBouncer & Pgpool to manage application connection pooling, pgBadger for log analysis and generating reports, pgDash, pgHero, pg top & pg activity for real time PostgreSQL DB monitoring, PG STAT ACTIVITY, PG STAT STATEMENTS, PG STAT USER TABLES, PGTune, pgstattuple, EXPLAIN ANALYZE, REINDEXING, PARTITIONS for better performance.
• Backup PostgreSQL databases using pg basebackup for physical backups (Compressed zip backups) and pgBackRest & BART for incremental and differential backups as well as pg dump and pg dumpall for logical backups.
• Configure Enterprise DB Failover Manager (EFM) on a PostgreSQL server to monitor streaming replication and automate failover for Application continuity.
• Performed Complete and PIT recovery on PostgreSQL clusters based on pre-defined Service Level Agreement (SLA) using pg restore and psql.
• Used AWS Management console to Configured and Managed PostgreSQL database instances on Amazon RDS.
• Performed Routine Postgres database and cluster wide maintenance activities like vacuum/vacuum full, Analyze, reindexing, and pg wal/pg xlog space maintenance.
• Used client-side applications like pgAdmin and psql to connect and manage PostgreSQL databases on-premises and on cloud.
• Create Security groups to control incoming and outgoing traffic from PostgreSQL Database Instances in AWS cloud. Create read replicas on Amazon RDS Postgres for read scalability.
• Automate daily full backup and Manual snapshot backups of PostgreSQL Advanced Server Databases running on cloud.
• Configuring and fixing the Issues wif Pgadmin-4.5 client application. Responsible for monitoring environments using monitoring tool viz. Nagios, Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tail mail. Experience wif installing, configuring, and managing the EBS platform
• Upgrade and applied patches to EBS as required
• Lead discussions in applying Oracle EBS technology to solve complex implementation issues and RICEW development challenges
• Experience wif installing, configuring, and managing the EBS platform
• Supported the E Business Suit application to setup access control and security policies by defining roles, role inheritance hierarchies, registration processes and role categories on the administration end as well as other applications such as AUTOSYS, SERVICE DESK.
• Patched the EBS through the Critical Patch updates and also perform an online patch to 12.2.9 recently for exploitation of the new features and security fixes. Also used EBS for automating customer relationship management (CRM), enterprise resource planning (ERP) and supply chain management (SCM) processes wifin our organization
• Ability to read and modify PL/SQL, SQL, database triggers, stored procedures, UNIX and Linux shell scripting

Confidential, Deerfield, IL

Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Contributed to the installation, configuration, and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) wif ASM file system on AIX platform.
• Installing, configuring, and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Supported production box running on Exadata X5 -2 and used the CELLCLI, DCLI, SQL, ASMCMD, SRVCTL, CRSCTL to manage Exadata machines. I has shut down and started Exadata machines based on Business needs and Familiar wif the Flash Cache and the Hybrid compression columns.
• Migrated databases into Exadata and registered them in a cluster environment and applied patches as well on databases running on Exadata.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Ran Scripts for Health Check on Exadata Storage Servers.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies. Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
• Implemented Flashback technology of the Oracle 11g, 10g along wif Recycle Bin for a faster recovery of the databases and database objects
• Implementing conventional export/import utility, datapump of Oracle 11g, 10g for refreshing Databases/Schemas/Tables to improve the performance.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production databases.
• Worked closely wif the Oracle developers for the better performance in Applications in writing the Packages, Triggers, and Indexes on the tables.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Successful in applying RDBMS patches, security patches for security and functionality of the databases.
• Made optimal use of Oracle Support in resolving the SRs and documented the Standard Processes for peers to follow and also use service now ticketing system to resolve tickets based on severity and to resolve those assigned particularly to me.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked closely wif Developers using oracle Apex in PLSQL to develop web applications and for scalability in RAC and to create mock-ups using pre-built themes .
• Provided 24x7 Production Support, troubleshooting / resolving various types of production issues.
• Years of experience working on SQL SERVER databases, creating databases, backups/recovery, security, refreshes, and availability solutions (MIRRORING, LOG SHIPPING, Window Failover Cluster Server. Hands on experience on SSMS, SSRS, SSIS, SSAS for reporting, integration, and analysis respectively as well as working on SQL server availability solutions in enterprise edition.
• Installed PostgreSQL 9.6 cluster using RPM installation and worked closely wif PostgreSQL developer in the configuration and capacity planning of our PostgreSQL database clustered environment on premises and capacity planning.
• Enforced security through the configuration files (pg hba and postgresql.conf) specifying the connect description only for company’s defined users and clients.
• Creation roles and granting just necessary privileges to each role. Renewing database certificates and creating new certificates for client ssh connections

TECHNICAL SKILLS:

OPERATING SYSTEMS : HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows.

RDBMS: Oracle 10g/11g/12c/18c, PostgreSQL 9.6 - 11.2, Microsoft SQL Server 2012-2017

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting, PERL, Python scripting.

TOOLS : TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, WinSCP, Erwin, Informatica

Database Utilities : SQL *Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Datapump, Export, Import.