US CITIZEN An Accomplished Oracle Database Administrator with almost 7YEARS of experience in Oracle Database Administration in large-scale production environments across multiple platforms Ability to provide technical support in all aspects of database administration including upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Data Guard. Ability to work both as an individual and as a member of a team.
Skills
TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.
Languages :
SQL, PL/SQL, UNIX Shell Scripting, PERL, T-SQL.
Tools and Utilities:
RMAN, OEM, SQL
Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer, SQL Server Integration Services SSIS, SQL Server Management Studio, Microsoft Team Foundation Server .
RDBMS :
Oracle 9i, 10g, 11g, 12c, 19c, MS SQL Server 2012
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, 7.0, RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000/2007, Windows Server 2008 R2 Enterprise.
SKILLS SUMMARY
Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
Worked on Data transferring with export/import utilities and Data pump.
Experienced in performance monitoring/tuning/troubleshooting.
Bind, Databases, Meetings, 3.x, OS, Developer, Progress, Sun Solaris 2.5, TOAD, Upgrades
C, Designing, Access, Windows 95, Operating Systems, PL/SQL, Quality, Sun Solaris, T-SQL, Upgrade
Work History
12/2020 to Current
ORACLE Server Database AdministratorChickasaw Nation Industries – Chicago, IL,
ORACLE/SQL DATABASE ADMINISTRTOR, I Support more than 2500 databases including development/test/production sizes up to 4 TB for 24/7.
I carry on relinking after an OS upgrade to bring up services and link bind variables.
I Upgrade databases up to 19c.
I do Backup and recovery using RMAN utility and Data pump.
I Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
I Setup and document Oracle Golden Gate replication on all versions for support team.
11/2019 to 12/2020
Oracle Database AdministratorTATA CONSULTANCY SERVICES, AXA – City, STATE,
I support about 2000 databases in dev, int and prod environment with the biggest ranging at 3TB.
I am responsible with given VM specs for the creation of new databases by the build team and after creation, I am responsible with the installation of oracle software and client installation on those VMS.
As a DBA, I create the new databases needed on the VMs and make sure that all necessary files and backup scripts are in place for daily incremental backups and properly saved for recovery purposes.
I make sure to patch the oracle homes as well as databases with the latest patch set before databases GO LIVE.
I upgrade databases from current version to newer versions such as 19c.
In my environment, I am in charge with migrating databases from CORE to AZURE since everything is being moved to Cloud.
On a weekly basis I migrate 3 to 4 databases for Dry Run and twice a month do all necessary preparations as well as implement the cutover by bringing the production database to Live.
Daily I work very close with customers with troubleshooting issues they encounter, such as creating new IDs, granting privileges, giving the right permissions to directory as well as authentication methods for users to access data.
I do both database refreshes as well as schema refreshes on a weekly basis and some weeks daily to keep data current for dry run testing before Prod cutover using Db_links.
I use Rman for backup and Restoring databases to other servers for replication.
On my daily activity I attend various meetings to bring in ideas on how to plan the migration of databases as well as bring the applications to live.
I am in a team of two oracle DBAs and I am still very able in making sure all task is completed in a timely manner for business continuity purposes.
03/2016 to 11/2019
ORACLE DATABASE ADMINISTRTORTATA CONSULTANCY SERVICES, BOEING – City, STATE,
I Support more than 2500 databases including development/test/production sizes up to 4 TB for 24/7.
I carry on relinking after an OS upgrade to bring up services and link bind variables.
I Upgrade databases from 10g to 11g (11.2.0.3 to 11.2.0.4) and newer versions.
I Install Oracle Homes 11.2.0.4 on development, test and production servers and apply Oracle Home patches.
Primary DBA for 1GB - 2.5TB database for 24/7 support.
I do Backup and recovery using RMAN utility and Data pump.
I Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
I Setup and document Oracle Golden Gate replication on 11g for support team.
I also Develop, revise and implement policies, standards, procedures and guidelines necessary to effectively administer the database environments.
I work close with my team to ensure databases adhere to corporate standards and policies.
By this, I Work with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
Monitoring and maintaining 2/3 node RAC database on Red Hat Linux.
Providing support to the development team and handling release schedules.
Maintaining sound backup and recovery policies and procedures using RMAN.
Monitoring the scheduled backup procedures for daily basis using crontab and Autosys.
I use ASH, ADDM and AWR reports to monitor database performance and also do Database refreshes using export /import and data pump.
I Perform Database Tuning & Performance issues, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
I Implement SQL outline to get the better execution plan for the offending queries.
On a Day to Day General Administration, I do Table space Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
I performed various tasks like Administering RAC using SRVCTL, adding nodes and instancing for High Availability purposes.
Refreshed multiple databases for Development and Testing upon short request.
Served as part of a 40-member DBA team which was involved in the maintenance of the Oracle 10g/11gdatabases for the Production as well as the development environments.
Actively involved in designing/Testing of Disaster Crash recovery.
Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
06/2014 to 02/2016
KFORCEOracle AES APPLICATION DATA ENGINEER SERVICES, NATIONWIDE INSURANCE COMPANY – City, STATE,
Work closely with customers on a daily basis to understand their needs,.
Support business change and deliver a consistently high-quality customer experience.
Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
Applied patches 10.2.0.2 and 11.2.0.3, 11.2.0.4.
Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11G RAC.
Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
Use to run the scripts Used to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
Support client customizations, sharing implementation and best practices advice.
Provide hands-on assistance using proprietary tools in a test environment.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
