We provide IT Staff Augmentation Services!

Sr. Oracle Database Administrator Resume

Washington, DC

SUMMARY:

  • Over 10 years of experience in System Analysis, Design, Development and Administration on Oracle 9i/10g/11g/12c Database.
  • Upgraded the Databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.3 to 12.1.0.0 and applied patches according to the client requirement.
  • Around 3 years of experience in MS SQL SERVER 2012/2008R 2/2008//2005/2000 Database
  • Administration and Development in Windows environment.
  • Around 2 years of experience in PostgreSQL 9.4 Database Administration
  • Good experience in setting up and administration of SQL Server, PostgreSQL and Oracle databases in
  • Worked on AWS environment.
  • A well - organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skills.
  • Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Good experience in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager functionality using TSQL Scripts and Batches
  • Experience in Installation, Configuration, up gradation and Maintenance of Oracle Databases.
  • Installed, Upgraded and Maintained Oracle RDBMS on Linux, UNIX & Windows platforms.
  • ACHIEVED High Availability, Scalability and Performance by determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw devices for Oracle RAC.
  • Installed and Monitored Oracle 11g/10 g RAC software and experienced on Performance Tuning on RAC.
  • Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
  • Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc.
  • Expertise in creating primary database storage structures (Table spaces) and primary objects (Tables, Views and Indexes).
  • Hands on experience with tools like SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM), and TOAD.
  • Hands on Experience in Space Management, Capacity Planning.
  • Creating Users, Roles and Profiles, Privilege management with role-based security.
  • Backup of database Logical and Physical (hot and cold) using Backup script procedures and also using RMAN.
  • Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard).
  • Handling Tools such as Toad, SSH, SQL Navigator, and OEM.
  • Ability to work under extremely tight deadlines and can maintain focus on objectives and processes and troubleshooting, implementation and development skills.
  • 24x7 production database support.
  • Keep abreast of current and emerging technologies to maintain skills levels necessary to provide quality service to customers.
  • Proficient in documenting the processes.
  • Good communication and Interpersonal skills.
  • Commitment to team work concepts.
  • Effectively handle multiple tasks simultaneously and have ability to acquire and apply knowledge rapidly.
  • Co-ordination with Confidential for technical support, new products and releases, technical discussion/support.
  • Experience in using tools like SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager
  • Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
  • Amazon Web Services; As a passionate advocate of AWS within Gracenote, I migrated my department from a physical data centre environment to AWS. I also designed, built, and deployed a multitude applications utilizing almost all of the AWS stack (Including EC2, R53, S3, RDS, DynamoDB, SQS, IAM, and EMR), focussing on high-availability, fault tolerance, and auto-scaling.

TECHNICAL SKILLS:

Operating Systems: Linux, UNIX, Sun Solaris, AIX 4.2, HP-UX 11i.

Hardware Platform: Windows, HP-UNIX server, RHEL-AS 2.1.

Languages: SQL, PL/SQL, C, Bash & Korn Scripting, PERL Scripting.

Tools: SQL, Import/Export, Import/Export data-pump, RMAN, SQL*LOADER, AWR, STATSPACK, iSQL*PLUS, TOAD, ERWIN, Procedure-Builder, SQL*PLUS, Enterprise Manager Grid Control and Database Control, Knowledge of Oracle Internet Application Server, DBCA, OUI, Working Knowledge of Data Guard.

DBMS Tech: Oracle 9i, 10g, 11gRAC,12c,12c OEM

CLOUD Technologies: AWS \ RDS \ EC2

Microsoft tools: Microsoft Office and Excel 2016/2010/2007/2003/2000

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. Oracle Database Administrator

Responsibilities:

  • Develops, documents and rolls out standard process for implementing database and system patch upgrades and new Oracle 12c database environment build.
  • Defines, refines, and standardizes database performance and tuning practices.
  • Refines and manages baseline configurations for the Confidential database environment.
  • Automates routine database functions to ensure accuracy and minimize costs.
  • Establishes and practices a consistent database backup and recovery practice that complies with the Confidential backup and retention policies and business continuity practices.
  • Performs migration of corporate database systems from Windows to Linux.
  • Performs migration of corporate databases from Oracle 11g to Oracle 12c.
  • Develops and follows upgrades procedures to ensure consistency within all Confidential databases.
  • Conducts performance testing and reports on impact of Oracle 12c upgrade on Confidential applications.
  • Enhances the Confidential data replication processes to reduce the amount of time between replication using Oracle golden gate 12c.
  • Provides 24x7 operational support of corporate production databases on a rotating schedule.
  • Performs routine production database and application maintenance tasks on a rotating basis.
  • Monitors all production database activity for operational improvements to include, but not limited to CPU, Disk and Memory utilization, space utilization, replication and consistency of sites, long running queries/data loads, query access plans, security infractions and overall performance of databases Develops and implements corrective measures for database issues/problems found during monitoring.
  • Provides database technical support for Technology and Application Delivery projects to include, but not limited to: analysis of database design and schema, database environment provisioning, security assessments, database build executions, database application performance testing/tuning and supporting project deployments. Leads and manages all database aspects of the assigned technology delivery project.
  • Provides database technical support in maintaining and building the database non-production environments, including database refreshes, database patch management, database space management, database performance tuning and migration/upgrade of the non-production database environments to Linux/Oracle 12c.
  • Acts as subject matter expert for all database systems; provides level 2 and 3 technical support for complex database issues. Provides technical input to software developers and end users in the areas of database capabilities, performance and best practices.
  • Provides training and guidance to peers and Database Administrators.
  • Recommends, creates, and follows all relevant policies and procedures to operate a controlled production environment.
  • Leads and manages database administration activities as assigned by the Lead Database Administrator.
  • Performs other duties as assigned.

Confidential, Vienna, VA

Sr. Database Administrator

Responsibilities:

  • Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
  • Installation, Configuration and Administration of Oracle RAC 11g/12c Databases on Oracle Enterprise Linux.
  • Partitioning of the tables for better performance and manageability.
  • Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
  • Worked on Grid control Oracle Enterprise Manager 13c (OEM)
  • Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.
  • Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
  • Install, configure and support uni-directional Oracle-to-Oracle replicated environments utilizing Golden Gate for reporting.
  • Using the GolgenGate Process to masking the sensitive data for reporting.
  • Masking the Critical Sensitive data using Oracle Masking process and Implement the fully automation of masking process using EMCLI tool.
  • Applying the PSU patch every quarterly for every Prod and Lower environment in the database and Yearly on Cluster using Rolling Fashion.
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
  • Managed appropriate use of free space within tablespaces, reclaimed space whenever possible.
  • Reorganized tables and indexes within databases when needed.
  • Creating the 12c multitenant cluster database for new application and provide the end to end support to configure the application to connect 12c database.
  • Administer all WebLogic servers, domains, clusters in all environments: Production and non-Production
  • Design and implement Oracle Fusion Middleware components for systems integration on WebLogic 11g and OAS 10g platforms
  • Integrated Oracle Access Manager 11g, OID 10g/11g on WebLogic 11g with OHS 11g web server
  • Implement, Maintain, and Troubleshoot WebLogic SSL/LDAP integration with SSO (OSSO 11g)
  • Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
  • Installed and configured Golden Gate JAgent to work with OEM GoldenGate Plugin.
  • Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.
  • Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
  • Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
  • Monitoring the availability of system, listener, database, alter log file, trace file.
  • Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
  • Supporting both production and development activities.
  • Creating of databases for Testing, Development and Production.
  • Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
  • Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
  • Written PERL and UNIX shell scripts for digitization the process.
  • Load balancing, databases/schema/table re-organization for faster performance.
  • Performing Capacity planning and evaluations with regular Maintenance cycles.
  • Installation of Oracle version 10g on Linux.
  • Applying patches whenever required.
  • Migration of Database from 9.2.0.6 and to 10.2.0.2 using DBCA and Performed Validation tests.
  • Extensively used SQL server BCP utility and IMPORT/EXPORT to load the database from text files received from different applications Continuous Performance Monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc.
  • Monitoring and Troubleshooting of Database Replication issues using Shareplex Tool.
  • Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different Tablespaces.
  • Performance Tuning of Oracle Database Objects.
  • Taking periodic Backup of the database and the software using RMAN.
  • Handling Database storage, Reading Alert. Log and User trace Files and Diagnosing the Problem, Scheduling jobs through Oracle job Scheduler.
  • SQL Tuning for Performance of Objects.
  • Automation of Startup Shutdown on all Production and Development Database.
  • Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, Scripts for Cold Backups, Script to check Oracle errors in alert log file and Send Mails.
  • Assisted with capacity planning, implementing and documenting SQL Database migration for Relius custom.
  • Created SQL Server audits and policies to monitor activity on SQL databases to ensure databases were in compliance, and met the Service Level requirements of our clients.
  • Scheduled full, differential, and transactional log backups for user created databases in production environments.
  • Responsible for setting up security, and providing user access to SQL Server instances and objects.
  • Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV's.
  • Assisted our development team with writing effective T-SQL stored procedures and views.
  • Responsible for setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.
  • Configured, and supported and Log Shipping and Database Mirroring strategies to support our client's High.
  • Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments.
  • Participated in on-call schedule to respond to SQL Server alerts and potential production database issues.
  • Involved in all AWS database technologies like Oracle, PostgreSQL, Sql Server.
  • Involved in designing and deploying a multitude applications utilizing almost all of the AWS stack (Including EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM) focusing on high-availability, fault tolerance, and auto-scaling.
  • Have knowledge on Cassandra.
  • Experienced on MariaDB creation and support.
  • Migrated the current Linux environment to AWS/RHEL Linux environment and used auto scaling feature.
  • Install and configure chef server / workstation and nodes via CLI tools to AWS nodes.
  • Increasing EBS backed volume storage capacity when the root volume is full using AWS EBS Volume feature.
  • Created AWS Route53 to route traffic between different regions.
  • Deployed and supported Memcache-AWS ElastiCache.
  • Working with GitHub private repositories.
  • Created S3 backups using versioning enable and moved objects to Amazon Glacier for archiving purpose.
  • Used Chef for configuration management.
  • Used GZIP with AWS Cloudfront to forward compressed files to destination node/instances.
  • Created users and groups using IAM and assigned individual policies to each group.
  • Created SNS notifications and assigned ARN to S3 for object loss notifications.
  • Configured Security group for EC2 Window and Linux instances and also for puppet master and puppet agents.
  • Experience with monitoring tools such as Cloud Watch.
  • Environment: AWS EC2, VMWare, Windows 2008, JBOSS, Tomcat Apache, Oracle, CLOUD WATCH, CLOUDFORMATION, GRUNT, GIT, CHEF, LINUX, Data Center Migration AWS, Jenkins, EC2, Chef, LINUX, Maven, GIT.
  • Amazon Web Services; As a passionate advocate of AWS within Gracenote, I migrated my department from a physical data centre environment to AWS. I also designed, built, and deployed a multitude applications utilizing almost all of the AWS stack (Including EC2, R53, S3, RDS, DynamoDB, SQS, IAM, and EMR), focussing on high-availability, fault tolerance, and auto-scaling.
  • Optimized the configuration of Amazon Redshift clusters, data distribution, and data processing
  • Designed, developed and migrated existing SQL databases.
  • Automated DBA activities and upgraded existing databases.
  • Maintained and optimized database application performance through tuning.
  • Generated database reports such as financial data statements and user data.
  • Suggested latest updates for games and evaluated database issues.
  • Administered and executed complex databases for critical problems.
  • Implemented system backup procedures and updated site resources.
  • Prepared automation scripts and developed PostgreSQL database architecture.

Environment: Oracle 10g, SQL SERVER, Oracle RAC on Linux, Toad, RMAN, SQL*Plus, SQL, PL/SQL, SQL*LOADER, Oracle OEM, Import/Export.

Confidential, NY

Sr. Oracle Database Administrator

Responsibilities:

  • Implemented 100TB of Backup system for Exadata databases machine and Exalogic Elastic cloud computing servers & VDI environment involving Oracle ZFS 7420 storage systems and HP Data protector 6.11.
  • Patched 11g Grid Infrastructure & RAC databases on Exadata Database Machines.
  • Patched Oracle Exadata Machine 11g R2 Grid Infrastructure and RAC databases. Involved in Exadata switch patching and cell storage.
  • Configured Oracle Grid monitoring system for Exadata database machine & Exalogic on separate network.
  • Implemented Oracle Virtual Machine virtualization 2 node cluster on HP Blade G470c servers for different needs.
  • Implemented Database Listeners on infiniband network from Exadata Machine to Exalogic Machine.
  • Worked on Scan listeners for 11g grid infrastructure.
  • Administering Cell Storage servers for Exadata Database Machines.
  • Extensively Administered Oracle Apps r12, 11.5.10 e-business applications on RAC.
  • Upgraded Oracle APPLICATION 11.5.9 to 11.5.10.
  • Patched, Cloned and administered Oracle Apps 11i with ad utilities (ADADMIN, ADPATCH, ADCTRL, and ADMERGE).
  • Solved issues related to Concurrent Manager on oracle apps 11i.
  • Provided installation, configuration support of Oracle RAC9i, 10g, 11g RAC databases from building server to installing databases.
  • Involved in upgrading Oracle9i to Oracle10g database
  • Configure workflow notifications, printers, and form servlets in Oracle financial applications.
  • Cloned 2-tier, 3-tier eBusiness suite application from production to test environment.
  • Involved heavily in different kind of cloning requirements. Restoring databases in same cluster system and different cluster system to other database.
  • Worked extensively on HP data protector and managed system wide backups. Configured backup polices for oracle databases and system wide backups.
  • Involved in patching 10g ASM instances and CPU patching for RAC instances and single instances.
  • Performed 10.2.0.3 Oracle RAC Cluster ware upgrade to 10.2.0.4. Upgraded 10.2.0.2. databases to 10.2.0.4

Environment: SQL Developer, TOAD, Spot Light, VMS Server

Confidential, Reston, VA

Sr. Oracle Database Administrator

Responsibilities:

  • Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
  • Installing Oracle Golden Gate for EBS Reporting Databases
  • Oracle and SQL server Database Capture using Oracle Golden Gate 11g
  • Data Extract, Conversion and Load using Golden Gate
  • Configuring Extract Parameters for Golden Gate EXTORA, RMTHOST, RMTTRAIL
  • Configuring Replicate Parameters ASSUMETARGETDEF, REPOR, DISCARDFILE
  • Creating GLOBALS for Golden Gate and Adding database checking points.
  • Migrated the data from old storage to a new EMC INVISTA Storage to minimize downtime and provide High Availability.
  • Migrated data on different Oracle versions of 9i and 10g, 11g and on different operating systems of AIX/Sun Solaris/Linux.
  • Migrated data from File System/Non - ASM to ASM storage.
  • Migrated data from ASM disks to ASM disks by using Rebalancing techniques.
  • Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 5
  • Production databases and few development databases.
  • Recovered data files from block corruption using RMAN.
  • Reduced production outages by implementing best practices of patch management, purge/archival, code
  • Optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV, QA and Staging.
  • Taking backup of databases using RMAN.
  • Used tools like export/import and data pump export/import.
  • Involved in export and import of database objects in order to copy them from one database to another &for backup the tables.
  • Created a physical standby for Disaster Recovery (DATA GUARD).
  • Experienced writing UNIX scripts and troubleshooting issues.
  • Upgraded Real Application Cluster (RAC) from Oracle 9i to Oracle 10g on HP-UX.
  • Used tools like TOAD, SSH.
  • Involved in Database Tuning for the performance of databases.
  • Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
  • Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as TKProf, STATSPACK, Explain plan and SQL*Trace.
  • Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 9i/10g/11g, Oracle RAC/ASM on AIX/Sun Solaris/Linux/WIN, Oracle Golden Gate 11g (11.2.1.0 and 11.1.1.), Toad, SSH, RMAN, SQL*Plus, SQL, Import/Export.

Confidential, Richmond VA

Sr. Oracle Database Administrator

Responsibilities:

  • Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
  • Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
  • Supporting both production and development activities.
  • Creating of databases for Testing, Development and Production.
  • Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
  • Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
  • Written PERL and UNIX shell scripts for digitization the process.
  • Load balancing, databases/schema/table re-organization for faster performance.
  • Performing Capacity planning and evaluations with regular Maintenance cycles.
  • Installation of Oracle version 10g on Linux.
  • Applying patches whenever required.
  • Migration of Database from 9.2.0.6 and to 10.2.0.2 using DBCA and Performed Validation tests.
  • Upgraded from SQL SERVER 2000 to SQL SERVER 2005.
  • Created and scheduled the packages using SQL server DTS packages.
  • Extensively used SQL server BCP utility and IMPORT/EXPORT to load the database from text files received from different applications Continuous Performance Monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc.
  • Monitoring and Troubleshooting of Database Replication issues using Shareplex Tool.
  • Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different Tablespaces.
  • Performance Tuning of Oracle Database Objects.
  • Taking periodic Backup of the database and the software using RMAN.
  • Handling Database storage, Reading Alert. Log and User trace Files and Diagnosing the Problem, Scheduling jobs through Oracle job Scheduler.
  • SQL Tuning for Performance of Objects.
  • Automation of Startup Shutdown on all Production and Development Database.
  • Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, Scripts for Cold Backups, Script to check Oracle errors in alert log file and Send Mails.

Environment: Oracle 10g, SQL SERVER, Oracle RAC on Linux, Toad, RMAN, SQL*Plus, SQL, PL/SQL, SQL*LOADER, Oracle OEM, Import/Export.

Confidential

Oracle DBA

Responsabilités:

  • Working closely with functional and development teams, involved in migrating of data from legacy system
  • Configuring the Printer (Style, Driver, Type) compatible to the reports
  • Applying Patches/Patchsets/Mini-packs on database using Adpatch
  • Monitoring the Database Growth and providing proactive Space Management for database of 50+ GB
  • Designing the Backup Strategy, Testing Strategy, Taking Backup (Cold/Hot), Maintaining Backup and Archived files on tapes and Restoring / Recovering the database as and when required
  • Configuring the Production Database to be in ARCHIVELOG Mode with mirrored Control, Redo Log files
  • Developed Shell Scripts
  • Refreshing the Development and Test instances (in NOARCHIVELOG Mode) with Production
  • Data stage Administration and Support
  • Validate / Schedule / Run / Monitor Jobs using Datastage Scheduler.
  • Cloning Oracle 11i Instance for development and testing purpose.
  • Create and maintain custom responsibilities and menus.
  • Designed and maintained schemas involving creating tables and indexes with scripts,
  • Creating triggers, and creating procedures.
  • Used the oracle NET8 Configuration Assistant to establish network sessions between client and server machines using host names and local names methods. (Configuration of TNSNAMES.ORA and LISTENER.ORA).
  • Responsible for troubleshooting of the connectivity problems for end- users by configuring tnsnames.ora, listener.ora and sqlnet.ora files.
  • Allocating system storage and planning future storage requirements for the database system.
  • Maintain database security, user roles and access profiles, involved in taking cold and hot backups.
  • Daily monitoring and checking the Background Dump File (alert SID Logs) and User Dump Files for errors.

Environnent: Oracle Applications 11i, Oracle 9i, Linux, HP-UX

Confidential

Oracle Database Administrator

Responsibilities:

  • Installed 9i, 8i, database on Windows 2000 and SUN SOLARIS.
  • Backup of database using RMAN
  • Wrote control files for SQL * loader to load data into data warehouse.
  • Provided database related services to their development and QA environments.
  • Was actively involved in constant site enhancements along with developers - code and data push between different servers and testing and moving to production.
  • Logical and Physical backup procedures.
  • Data exports from production and staging databases.
  • Tuned SQL queries to pull data from data warehouse tables.
  • Tuned production database performances and was instrumental in SQL tuning that improved application response.
  • Run oracle stats pack to tune the databases.
  • Wrote SQL scripts for DB monitoring, and online backups.
  • Implemented database related security measures that proved very effective.
  • Implemented Oracle Replication to enable database fail over in case of system or database crash.
  • Backup and recovery using cold, hot and export methods.
  • Wrote database triggers, functions and procedure by using PL/SQL.
  • Automated a no. of database related jobs.
  • Set multiple destinations for archives redo logs for safety.

Environment: Oracle 9i, UNIX-AIX 4.2, Window 2000.

Hire Now