We provide IT Staff Augmentation Services!

Team Lead/senior Oracle/sql Server Database Administrator. Resume

Reston, VA

SUMMARY:

  • Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS.
  • Experience with Oracle Golden gate 12c
  • Performed Oracle database Upgrade and Migration from Oracle to 10g to 11g and 12c
  • Installation and management of Oracle Enterprise Manager Cloud Control 13c
  • Performed database upgrade from 10201 to 10204
  • Installation and management of Oracle database using Grid and database control
  • Installation and application of several Oracle critical patches to various database versions
  • Monitoring, optimizing and allocating physical data storage for database systems.
  • Management of oracle automatic storage management (ASM)
  • Installing and configuring relevant network components to ensure database access as well as database consistency and integrity.
  • Established, implemented and maintained comprehensive Oracle database maintenance plans.
  • Developed, implemented and maintained an Enterprise Oracle backup, recovery and disaster recovery strategy.
  • Implemented the use of Oracle Recovery Manager (RMAN) to backup the databases.
  • Performed import and export as needed and scheduled nightly export on databases.
  • Perform various RMAN cold and hot backups.
  • Troubleshoot and resolve various Oracle problems such as connectivity problems, backup and performance issues.
  • Perform maintenance and related preventative maintenance on databases
  • Providing Oracle network troubleshooting, technical and administrative duties
  • Applying D.I.S.A STIGs to Oracle Databases.
  • Applying D.I.S.A STIGs to MS Sql Server instances and Databases.
  • Experience with AWS
  • Created and managed documentation on the configuration and support of the Oracle databases.
  • Perform bulk load into the database using SQL Loader.
  • Tune the database and applications for faster and better performance.
  • Performing goal - oriented tuning as necessary.
  • Working knowledge of Graph db
  • Installation, management and configuration of oracle fusion WebLogic.
  • Experience tuning SQL queries and database performance for OLTP and DSS applications within various environments.
  • Installing and Configuration of Data Guard.
  • Configuring Data Guard Fast start failover with an observer.
  • Develop best practices based on associated security policies, industry security standards, and audit regulations to ensure devices are appropriately secured from security breaches Resolve compliance break-fix incidents based on vulnerability testing, audits, and/or associated security monitoring systems.
  • Performed fine grain database auditing.
  • Creating and maintaining Code repository.
  • Schedule jobs using various Oracle tools such as Oracle OEM, DBMS JOBS and SCHEDULER
  • Maintained stored procedures, functions, triggers, packages and views used by the database instance
  • Documented database structure, changes, problems, issues for future references.
  • Develop and enforce database related policies, standards, naming conventions, operating procedures and best practices.
  • Develop a strategic plan for the database development that supports the organizations operational requirements.
  • Administer database user accounts. Created, modified and deactivated user accounts.
  • Experience, Knowledge and understanding of Real Application Cluster (RAC) and Data guard.
  • Experience with the installation and configuration of Oracle Fusion WebLogic
  • Installation and maintenance of Microsoft Sql server 2012
  • Configuration of Microsoft Sql server 2012 high availability.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Team Lead/Senior Oracle/Sql server Database administrator

Responsibilities:

  • Providing technical support in development and high-availability production environments.
  • Data migration from production to test and Lab databases for robust testing and development
  • Configuring audit, granting privileges and restricting access, creating users, profiles, roles and monitoring quota on tablespaces in line with resource planning guide.
  • Managing, multiple databases and instances on Oracle and Microsoft SQL server.
  • Production support, testing, and development environment on a Linux platform.
  • Managing, installing and configuration of oracle.
  • Capacity Planning and resource allocation.
  • Performing Patches and system bug fixes as needed.
  • Configuring Sql Server 2012 high availability clustering.
  • Generating System documentation for various processes.
  • Creating projects in agile for team members.
  • Creating and managing eight 10 terabytes oracle databases
  • Applying D.I.S.A Stigs to Oracle databases
  • Applying D.I.S.A Stigs to Microsoft Sql Server instances and databases.

Confidential Mclean, VA

Senior Oracle DBA / Application Support /Change manager

Responsibilities:

  • Providing technical support in development and high-availability production environments.
  • Performed routine data migration from production to test and development databases for robust testing and development.
  • Configured audits, granted privileges and restricted access to databases.
  • Created users, profiles, roles and monitored quota on tablespaces in line with resource planning guide.
  • Managed 5-Terabyte, multiple databases and instances using RAC in a real time production support, testing, and development environment on a Linux platform.
  • Managing, installing and configuration of oracle fusion WebLogic for all environments.
  • Developedan oracle fusion weblogic run book for supported applications.
  • Generating Weekly ADHOC reports.
  • Responsible for Version Control using subversion
  • Coordinating enhancements and upgrades that are required for the IT Value application suite
  • Support activities to include: creation of change requests, writing scripts for the change request execution, code promotion using Dimension and/or ADMS
  • Using IT Remedy/service-now to monitor, support and promote Code to production environment.

Confidential Washington DC

Oracle DBA (Developer & Production)

Responsibilities:

  • Providing technical support in development and high-availability production environments
  • Data migration from development to production databases
  • Configuring audit, granting privileges and restricting access, creating users, profiles, roles and monitoring quota on tablespaces in line with resource planning guide.
  • Use Enterprise Manager DB console to monitor performance, clone databases, tuning and maintaining optimal performance, unit testing, database integration
  • Built multiple PL/SQL codes on 9i, Oracle 10g, 11g, 11gR2
  • Built codes based on documented requirements, performs unit testing
  • Capacity Planning and resource allocation.
  • Managed 4 3Terabyte databases and instances using DataGuard, RAC in a real time production, testing, and development environment.
  • Creating and monitoring standby databases to ensure high availability.
  • Install and patching of DBMS software, upgrades and related products in both production and development or test on various platforms.
  • Use DataPump for migration, Remapping, SQL*loader, import and export of database/schema/Tablespace.
  • Generating Reports and preparing memo to communicate progress and providing early alerts for major updates.

Confidential Gaithersburg MD

Junior Oracle DBA (Developer)

Responsibilities:

  • Develops/updates logical data model and physical data model.
  • Design database and migrate/convert data from legacy tables to new data structures
  • Used RMAN to backup database.
  • Worked daily on incremental backup and weekly on full database backup.
  • Used OEM to schedule backup.
  • Handled disaster testing.
  • Cloning and creating new databases using EM DB console.
  • Configured and implemented data warehousing.
  • Managed and monitored direct database access security, data integrity, enforcing constraints, and database privileges.
  • Configured and monitored the TNS Listener using NetCA, COST parameter.
  • Used Data Pump to implement database refresh with the hot backup using DUPLICATE or full export.
  • Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Responsible for Oracle logical and physical databases design, implementation and maintenance on UNIX.
  • Patched and installed of Oracle software.
  • Performed tuning using the AWR, ADDM (‘adam’) to guide tuning and maintain high database availability and reliability.
  • Provided direct consultation and support to projects or application developers in the areas of database architectural design, database conversion, independent testing, application development and database administration.

Confidential, Rockville, MD

System Engineer

Responsibilities:

  • Monitored hardware performance and carrying out periodic maintenance on hardware and network equipment.
  • Installed and configured new hardware, systems, and software for networks.
  • Managed backup and restored of systems to ensure that the network is up to date.
  • Worked with a team of IT professionals and Managed an IT task group comprising of 12 employees .
  • Performed troubleshooting and repairs of networks, analyze servers, workstations, and associated systems.
  • Monitored system performance to ensure that user’s experience ran smoothly.
  • Carried out performance tuning and system debugging.
  • Supervised network security and manager user accounts to ensure that company information were not compromised.
  • Conducted training and orientation session for new hires in IT department.

Hire Now