SUMMARY:

A senior database administrator with 14+ years of experience in multiple industries including banking/hedge fund databases. Experienced in managing very large databases of Confidential Companies.

TECHNICAL SKILLS:

Operating Systems: AIX 5.3/6, Linux, SOLARIS 5.8, WIN NT/2000, UNIX, MS - DOS.

Languages: PL/SQL, JAVA, HTML, Assembly language, Shell script

RDBMS: Oracle 12c,11g, 10g, 9i, 8i, MS Access 97, 2000.

SqlServer Tools: Replication

Backup & Recovery: High Availability

Health Analysis: Disaster Recovery

Db Administration: Documentations

Products Management: Upgrade & Config

Data Loading: Performance Tuning

Cluster Administration: Security

ORACLE Confidential: RMAN, Datapump & Legato Networker(MML)

Confidential, ORACLE Confidential:

Statspack, AWR: Data Guard

Toad, SqlNavigator, putty, Oracle Grid Control: MS-OFFICE products

OEM Grid Control: DBCA, DBUA, Opatch

SQL Loader: SQL Trace, Tkprof, ADDM, AWR, ASH, SQLT

Srvctl, asmcmd, crsctl, crs stat, ocrconfig, ocrcheck, ocrdump, vipca, netca: TDE, OLS

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr.Oracle DBA

Responsibilities:

• A production/Engineering dba with extensive migration and upgrade experience supporting quantitative databases.
• Supporting trading applications like EZE and HERMES.
• Provide support to in house reporting and Cognos.
• Extensive experience in planning & developing new processes which includes installation, migration, upgrades and patching.
• End-to-end datawarehouse deployments which includes data modeling, designing and normalization.
• Tune DW using different techniques like partitioning, introducing new indexes, restructuring sql, materialized views, hints and sql profiles.
• Refresh environments using SAN based ASM copy.
• Develop new shell scripts to monitor and perform daily purges.

Confidential, New York, NY

Sr. Oracle DBA

Responsibilities:

• Established/tested a migration process of a multi-terabyte datawarehouse from 11g to 12c using transportable tablespaces with incremental backups using new -features of 12c in a multi-tenant environment.
• Experience in installing 12c with container and pluggable databases.
• Managed Shareplex Replication.
• Implemented Transparent Data Encryption for database security.
• Implemented methodologies to secure database environments using roles/auditing and manage privileges accordingly.
• Secured data using data masking in test environments.
• Tuning databases both from physical and logical standpoint.
• Work with developers in identifying and optimizing problematic queries.
• Implement partitioning and indexes to optimize performance.
• Capacity planning for new deployments and migrations.
• Involved in a DW project implementing star schema and snowflake design.
• Involved in full regression testing using Real Application Testing for configuration/upgrades in production environments.
• Involved in a major upgrade and migration project of 10TB warehouse from a non- Confidential Oracle 10g on Solaris to Oracle 11gR2 Confidential on RHEL. Due to different endians, transportable tablespaces were used.
• Installation of Oracle Grid Infrastructure 11gR2 on RHEL.
• Installation of Confidential software on RHEL.
• ASM setup and maintenance using asmcd tool.
• Creation/Addition of Diskgroups and addition/removal of ASM disks with Fast Rebalance.
• Implement/Managed Dataguard with broker in both Confidential and standalone environments using different protection modes.
• Conversion of Non-ASM databases to ASM using RMAN.
• Performance tuning using AWR and ADDM reports.
• Implemented Confidential between oracle databases to replicate selected schemas.
• Used Confidential for Confidential in the migration project for zero downtime.
• Maintain and troubleshoot Confidential issues.
• Sqlserver installation.
• Setup Test environments.
• Database backups using management studio.
• Attaching and detaching databases.
• Apply Service Packs.
• Create users and assign permissions based on the level of access requested.
• Manage database backups and apply appropriate recovery model.
• Database restoration using backup pieces to a new location or to a new name.
• Involved in multiple DR instances i.e. loss of Master DB etc.
• Provide logical structural advice to improve performance.

Confidential, Commack, NY

Sr. Oracle DBA

Responsibilities:

• Involved in an upgrade and migration project of 2TB warehouse from Oracle 9i.
• Installation of Confidential software on RHEL.
• Worked with engineering team to deploy new softwares and push patches.
• Followed SOPs and guidelines given by database engineers to execute tasks.
• Troubleshoot dataguard in scenarios like loss of datafile/archivelog etc.
• Involved in extensive documentations of projects.
• Incidents management using ticketing system (Remedy).

Confidential, New York, NY

Sr. Oracle DBA

Responsibilities:

• A lead production dba managing production and development/test databases.
• Installation/Cloning of Oracle 9i, 10g, 11g software on AIX/Unix servers.
• Installation of Oracle Grid control.
• Test database refreshes using datapump and Rman duplicate.
• Resolving tickets generated by the ticketing center.
• Prepare and document disaster recovery plans.
• Involved in a Disaster Recovery project which included planning, implementation and a complete mock disaster exercise.
• Migrated production environments from Oracle 9i to 10g and then 10g to 11g.
• RMAN duplicate of production to test databases using nfs mount.
• Involved in massive policy renewals annually which involved techniques to speed up the renewal process.

Confidential, New York, NY

Oracle DBA

Responsibilities:

• Involved in a major Database migration project from 9i to 10g.
• Post migration tuning of application and database to achieve optimal performance.
• Created shell scripts frequently for new jobs or to automate an existing job.
• Wrote procedures and functions to fulfill our needs accordingly.
• Implemented customized scripts on critical databases to receive email/pager notification as part of a proactive strategy.
• Analyzed performance problems on both production and warehouse and took reactive actions.
• Organized database by moving tables between tablespaces and trimming relevant tables by making backups to speed up the access and making backups smaller.
• Setup SQL *Loader scripts to run automatically to load data for the development and research team.
• Implemented flashback recovery mechanism for faster media recovery.
• Involved in installation of RHEL on Dell Poweredge Servers.
• Disk partition, iSCSI and RAID configuration in Windows and RHEL.
• Space management using Volume Groups and Logical Volumes.
• Migration of databases from windows to Linux operating system.
• Applying version upgrade, security (CPU) interim patches to databases.

Confidential, New York, NY

Oracle DBA

Responsibilities:

• Meet with clients to analyze their requirements and make decisions for Confidential implementation to meet their needs.
• Deployment of Confidential solution using 10g 5-Node/8-Node Confidential on HP-UX/RHEL.
• Installation of Confidential on shared device for Confidential on RHEL.
• Load balancing and Workgroup balancing using services.
• Tuned interconnect and eliminate contention in Confidential .
• Managed Dataguard in Confidential environment.
• Data modeling/logical database design using ERWin
• Involved in capacity planning and disaster recovery strategies.
• Provide 24x7 on call support and problem resolution as necessary.
• Data loading and extracting using SQL * Loader
• Implementation of Confidential with Dataguard using physical or logical standby.
• Troubleshoot Dataguard of many production environments.
• Shell and PL/SQL scripting for database automation
• Table partitioning using different kinds of partitions based on a client’s requirements.
• Fixing block corruptions occurred in table or index segment
• Creating and maintaining database links and materialized views for reporting purpose.

Confidential

Junior Oracle DBA

Responsibilities:

• Creating and maintaining all databases required for development, testing, training and production.
• Setup physical standby database as part of Confidential .
• Involved in system maintenance and health check using Spotlight.
• Reviewing and administering all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
• Performing database re-organizations as required to assist performance and ensure maximum uptime of the database.
• Identifying inefficient SQLs and rewriting such SQLs.
• Creating schema objects like tables, indexes and sequences etc.
• Outlined backup and recovery strategies using import/export and RMAN.
• Refresh data for developers using import/export .