SUMMARY

• 8+ years of experience as an Oracle and SQL Server Database administrator in Development and Production environments.
• Implementing High availability and Disaster recovery solutions to various customers in both Oracle and SQLServer.
• Profound experience in performance tuning and provided tuning suggestion for many mission critical Online Transaction processing systems and improved overall response time.
• Experience in troubleshooting locking issues, wait events, hang analysis.
• Profound Experience in Installing, configuring and administrating Exadata, Golden Gate, RAC, Datagaurd, SQLServer Clustering, Always on, log shipping and mirroring.
• Good understanding of key Exadata features including Exadata smart scan, Smart Flash Cache, Exadata Storage Index, Hybrid Columnar Compression and Exadata Storage Management & Administration
• Good Knowledge on data modeling and ERD.
• Good knowledge in SQL, PL/SQL, Shell Scripting and Perl scripting.
• Supported for 24X7 Production environments on - call standby.
• Experience in backup and recovery techniques on both Oracle and SQLServer databases.
• Experience in handling up-gradations and Migrations of Databases.
• Hands on experience in database patches installation, database security, capacity management, cloning databases.
• Profound experience in monitoring and Administrating RAC, Exadata, DR, SQLServer, Single tenant and Multi-tenant databases 12c.
• Proficiency in Oracle Grid Control, OEM 11g/12c
• Handling Data Guard Switch over and Failover in oracle and mirroring in SQL server scenarios
• Providing oracle trainings.
• Writing Scripts to Automate the Jobs.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, 12c, Exadata and Sqlserver .

Languages: SQL, PL/SQL, UNIX Shell scripting and Perl Scripting.

Operating Systems: Windows, Linux, AIX and Hp-Unix.

Database Tools: PL/SQL Developer,SSMS, TOAD, OEM grid & Cloud control, RMAN IMPDP/EXPDP and ERwin.

Disaster Recover: Oracle Datagaurd,Golden Gate, log shipping and Mirroring.

High Availability: Oracle Real-Application cluster, SQL server Cluster and Always on.

Performance tools: OEM 12c, TOAD, AWR, ADDM, ASH reports, OSWATCHER, SQLTOradebug, SQL server Profiler, Stats pack report and TKPROOF utility.

PROFESSIONAL EXPERIENCE

Confidential, NYC

Database Administrator

Responsibilities:

• Primary Responsible for handling 200+ databases both medium and large scale in which there are 44+ DR servers, 9+ RAC environments, 10+ sqlserver clustered environments, 4 Exadata environments, 4 Golden Gate, 50+ SQL servers and 70+ Oracle databases.
• Responsible as a lead for a team of 10 database administrators.
• Responsible for physical database design both single and multitenant, implementation and maintenance.
• Troubleshooting critical issues in both oracle and sqlserver databases.
• Creating and configuring PDB’s in 12c multitenant databases
• Handling Performance issues in both oracle and sqlserver.
• Writing PL/SQL programs and scheduling jobs.
• Monitoring Exadata server using OEM.
• Installation and configuration of golden gate environments for both single and bi-direction.
• Monitoring Golden gate environments.
• Performing data modeling tests on OLTP and Data warehouse, data marts using Erwin tool.
• Handling SQLServer clustering databases, Always on, configuring Log shipping, mirroring.
• Database Migration / Up gradation from 10g, 11g, 12c and sqlserver 2008/2012.
• Oracle Server & Client Installation on Linux/AIX/hp-UX and windows environments.
• Installed & Configured RAC with ASM in 11.2.0.3 Version.
• Applied Opatch in Development, Testing & Production Environment.
• Install EM agent and configure DB/Cluster instances in OEM 12c.
• Installed OMS & Web logic to configure GRID Console 11g R2.
• Creating ASM Disk & Disk groups and Maintaining Oracle ASM instance.
• Added Disk and REBALANCED.
• Migrating database From NON-ASM to ASM disk.
• Perform logical backups (using Export/Import or expdp/impdp utilities).
• Configuring new databases and users: set up backups, export, and other monitoring Scripts.
• Cloning an Oracle Database in Test environment from Production database.
• Configuring & Managing Shell Scripts like Monitoring scripts (Alert log, Instance check, High Load etc) & Backup scripts from remote server.
• Taken COLD & HOT Backup using RMAN & Manual method.
• Doing Recovery using RMAN & Manual method
• Wrote UNIX shell scripts for database administration, backup and performance monitoring.
• Check Alert Log errors and make necessary actions to rectify them.
• Controlling and monitoring of user access to the database including Granting and revoking of privileges and roles and table space quotas.

Environment: Linux, Aix, HP-UX, windows, Oracle 11gR2, 12c, SQL server 2012

Confidential, NY

Database Administrator

Responsibilities:

• Handled databases of various sizes running from 500GB to 5 TB of both Oracle and SqlServer databases.
• Was involved in Core DBA activities for around 72 Databases comprising of both production and non-production databases.
• Performing switchover for every 3months to test physical standby.
• Installing and configuring Oracle and SqlServer databases.
• Tuning Performance issues, pulling AWR, ADDM, ASH report and identifying issues.
• Database administration, managing tablespaces and DB objects.
• Creation of oracle users, roles, granting privileges and profiles etc.
• Enable monitoring scripts (like Alert log, Instance check, High Load etc).
• Check Alert Log errors and make necessary actions to rectify them.
• Preparing UNIX shell scripts for database administration and backup.
• Data Refresh from Prod to test database.
• Perform logical backups (using Export/Import or expdp/impdp utilities).
• Manage existing Shell scripts used for monitoring the databases
• Scheduled backups (like Expdp, RMAN,SQLSERVER backups, Archive log )
• Taking DR server reports via STATSPACK.
• Analyze SQL statements using Explain Plan, DBMS XPLAN.
• Oracle upgrading from version 10g to version 11g.
• Configured log shipping and monitoring.
• Applying patches
• Controlling and monitoring of user access to the database including Granting and revoking of privileges and roles and table space quotas.
• Routine DBA duties like analyzing schema's, monitoring database growth.
• Managing redo logs, checking alert log and trace files for database performance.
• Taking RMAN backups, installing oracle software, creating databases, Dropping Database.
• Restoring Backups, Cloning database.
• Configuring and Troubleshooting Listener related issues.
• Configuring and Monitoring Physical Standby.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Using OEM to monitor the database.
• Troubleshooting performance related issues.
• Creating users, indexes, monitoring tablespaces.
• Scheduling Cronjobs, inittab, increasing space in filesystems, UNIX administration.
• Also Administrating AIX, hp-unix, Linux, Solaris OS.

Environment: Linux, windows, Aix, Oracle10g, 11GR2, SQL server 2008, 2008 R2