Oracle DBA

Name: Sachdeep Singh

Skills: Oracle DBA Consultant

Phone No: 209-***-****

Email: **********@*****.***

_

PERSONAL SUMMARY:

• Having good experienced in Oracle Core DBA accomplished in delivering Administration, Design and Developing Applications, installation, support, upgrade & migration of multiple database versions, backup, recovery and dataguard.

• Over 6 years of experience in as an Oracle Database Admin (11g/10g) in Production and Development environment. Worked in 24x7 production environment and provided on-call and day-to-day support.

• Experienced as an Oracle Core DBA in Production Support and DBA tasks - Installation, Patching, Cloning, Upgradations and regular maintained activities.

• Successfully upgraded from Oracle 9i to 10g and 10g to 11g can support smooth and accurate conversions from legacy Oracle (other database upon assessment) to the latest release of Oracle. Also, applied time to time Oracle Patches to the existing Production, development and test environment databases

• Proficiency in Programming Languages PL/SQL and Shell Scripting. Hands on LINUX/UNIX Systems.

• Execellent experience in various migration techniques like import/export, datapump, backup restore, cloning and dataguard.

• Good in implementing Oracle server security through grants,roles and privileges.

• Experience in taking HOT & COLD backup of the database.

• performed switchover testing of standby database(DATAGUARD).

• Real Application Cluster (RAC) 11g.

• Extensively used Oracle Enterprise Manager OEM for maintaining and monitoring the database.

• I’m an adaptable and efficient team player with excellent communication skills at all levels. I’m looking for a role where I can develop my skills further, researching new technologies and reveling in new challenges.

TECHNICAL SKILLS:

• Oracle 10g.x/11g.x

• RHEL, OEL, Solaris, AIX, Windows, Unix.

• Data guard, Data pump, Migration.

• Upgradations, Patching, Cloning.

• User management, Security, Roles.

• Oracle Networking, SQL Scripting.

• RMAN, FRA

• PL/SQL, Statspack, Profiles.

• Shell Scripting.

• SQL Developer

PROFESSIONAL EXPERIENCE:

Client: Ascena Retail Group, Columbus, OH Oct 2016 to May 2017 Role: Oracle DBA

Responsibilities:

• Installation, upgrade, maintenace and patching of RAC/NON-RAC 11g/10g RDBMS

• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.

• Evaluated and implemented new technologies. Deployed and maintained 50+ servers that include VMware, Microsoft and Unix platforms

• Refreshed/instantiated Physical standby database using advanced 11gR2 features like Active Database Duplication (ADD) from stand-alone to 2-node.

• Used extensively Flashback’s feature of Guaranteed Restore point on standby-database to perform large sized data-exports to not disturb the Primary database and placed the database back to Standby mode

• Responsible in performing Dataguard Switch-over and Switch-back exercises during the maintenance window.

• Wrote shell scripts to automate the process of monitor file-system usage, switching Archive log destination, database monitoring etc

• Performed logical backup using export and import utilities. Creating tablespaces, tables, views, scripts for automatic operations of the database activities.

• Performing the daily tasks of a DBA including alert logs, backups, space management and health check of the databases.

• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

Environment: RAC 11g, Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, SQL Developer, Red Hat Enterprise Linux, RMAN, Data pumps, Exports/Imports. Client: Independent Health, Buffalo, NY May 2014 to Sep 2016 Role: Oracle DBA

Responsibilities:

• Oracle Core 11g Maintenance, Patching, and Database Support & Maintenance.

• Applied patches (One-off, Mini-patch, Rollup Patch, CPU) and performing AD activities and Trouble shooter several worker issues and used default files to reduce patch timelines.

• Resolve the view log/out files issue of concurrent requests, TAR support.

• Monitoring tablespace free spaces, re-sizing datafiles, Alert log trace files.

• Responsible for cold/hot and rman backups.

• Cloning Oracle Core 11.5.9, 11.5.10.2 from production to uat NON-RAC environment.

• 11g 2-Node installation and configuration.

• Performance analysis of different database objects. Development of the front-end functionality

• Create various Stored Procedures. Monitoring the Tablespaces Usage and Indexes usage regularly.

• Storage management, sizing the database objects, monitoring Disk usage. Monitoring the Backup Status. (Exports, Cold Backup, Hot Backup).

• Debugging the bugs in SQL using linux and troubleshooting end users problems. Migrating data using Import and Export utilities.

• Creating RMAN backup, recovery catalog.

Environment: Oracle Core 11g, 10g, RHEL 4.2, SQL, Windows 2003 with active directory, PL/SQL, OEM, SQL Developer.

Client: Health Information Management ON CALL, Allentown, PA feb 2013 to April 2014 Role: Oracle Database Administrator

Responsibilities:

• Creating HL-7 files using SQL scripting and PL/SQL. Supporting Medical Coding Department, Design and implement various structures for all physical objects.

• Worked as an Oracle Development DBA Supporting Development Team.

• Implementing and maintaining database security (create and maintain users, roles and assign privileges)

• Database performance monitoring.

• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.

• Compared schemas, databases, TNSNAMES.ora file and Tablespaces for better understanding of databases between test and production environment.

• Performed logical backup using export and import utilities. Creating tablespaces, tables, views, scripts for automatic operations of the database activities. Environment: RHEL, 10g, 11g, SQL, Oracle Grid Control, OEM, Database Control, SQL Developer. Client: BP (British Petroleum), Hyderabad, INDIA May 2011 to Dec 2012 Role: As contractor worked as Oracle DBA

Responsibilities:

• Installed and configured Oracle database binaries on AIX and Windows platforms

• Upgrading and migrating database from 9i to 10g version .

• Performed Backup and Recovery using RMAN and user managed techniques as per the need of the project management team

• Handling the work related to space management, user management, roles & privileges

• Monitored the database growth on daily basis. Established backup and recovery strategies.

• Responsible for taking hot backups and logical backups at schema, tablespace and database level

• Monitoring of Oracle database, automated error notification Enviroment: RMAN, 10g, sql, EXPORT,IMPORT, datapump EDUCATION:

Bachelor in Computer Application

Guru Nanak Dev University Amritsar, INDIA.

Contact this candidate