We provide IT Staff Augmentation Services!

Database Administrator Resume

Piscataway, NJ

PROFESSIONAL SUMMARY:

  • Over 9 years of experience as a IT Professional having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, Unix shell scripting and documentation.
  • Experienced in working on Oracle, Cassandra and MS SQL Server databases.
  • In - depth knowledge in Designing, Installation, Administering, Implementation, Configuring, Troubleshooting, Performance and Fine tuning of Cassandra cluster.
  • Upgrading Datastax Enterprise Cassandra versions.
  • Excellent knowledge on CQL (Cassandra Query Language) for obtaining the data present in Cassandra clusters.
  • Strong Knowledge in installing multi-data center and multi-rack Cassandra cluster.
  • Extensive knowledge on Cassandra database architecture with good understanding of read and write processes including SSTable, Mem-table and Commit log.
  • Implementing Cassandra on Amazon Web services (AWS) for EC2 Instance.
  • Installation and Configuring SQL Server databases.
  • Worked with Oracle Databases (12c,11g/10g) on Unix/Linux/Windows platforms.
  • Planned and implemented DR & high availability solutions using Oracle 11g RAC & 10g RAC, Standby Database (Oracle Data Guard).
  • Worked on database recovery techniques and implementation of those recovery techniques to ensure business continuity.
  • Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN and manual methods.
  • Experience in trouble shooting RMAN issues in performing the Backup and Recovery process.
  • Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
  • Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
  • Performing daily activities and troubleshooting the database issues using OEM Grid control.
  • Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, SQL TRACE, custom scripts troubleshooting oracle databases using sqltrace utilities.
  • Have good Working knowledge of disaster recover models with experience in implementation and recovery of Oracle databases and RAC clusters.
  • Experience in Upgrading databases, applying patches.
  • Good experience on Oracle Support processes for technical requests through Metalink and other Support Procedures
  • Experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
  • Worked on all backup and restore scenarios for SQL Server databases.
  • Proven ability to adapt to demanding schedules and changing priorities and ability to function successfully in a highly stressful and critical environment.
  • Strong analytical and problem-solving skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS:

Operating Systems: HP-UX, Sun Solaris, AIX 5.1, 5.2, 5.3RedHat Linux RHEL 7.0 and Windows.

RDBMS: Oracle 11gR2, Oracle 10g, Oracle 9i, Oracle GoldenGate 11.2.1, Oracle 11g (RAC), Oracle 10g (RAC). SQL Server 2008,2012.

NoSQL Databases: Cassandra

Cloud Technology: Amazon web Services (AWS), EC2 cloud.

Languages: SQL, CQL, UNIX Shell.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD, OPS CENTER

Tools: /Utilities: Putty, Super Putty OEM GRID, SSH, WinSCP, Explain Plan,AWR, ADDM, Nodetool, Spark.

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Database Administrator

Responsibilities:

  • Provide support for ORACLE, CASSANDRA and SQL SERVER and Databases.
  • Designing, Install, configure and maintenance of Cassandra clusters.
  • Extensive knowledge on Cassandra database architecture with good understanding of read and write processes including SSTable, Mem-table and Commit log.
  • Troubleshooting issues and tune memory parameters on Cassandra DB’ for better performance.
  • Develop scripts for Startup and Shutdown and Health Check reports for Cassandra Databases.
  • Worked on CQL (Cassandra Query Language) for obtaining the data present in Cassandra clusters.
  • Migrating data from oracle database to Cassandra databases.
  • Involved in the Performance and Load Test for Cassandra Databases.
  • Implementing Cassandra on Amazon web services (AWS).
  • SQL scripts to monitor Table spaces and Extent growth.
  • Cloned environments to create patch test, development and QA environments for ORACLE and SQL SERVER databases.
  • Provided disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data. Maintain and implement policies for ensuring the security and integrity of the database.
  • Coordinating with System Admin and Middleware Teams for smooth implementation of production Tasks.
  • Provide ON-Call support for ORACLE, Cassandra and SQL and Databases.

Environment: Cassandra 4.8.14, Spark, OPS Center 6.0.9, Oracle 12c,11g R2, RAC/11g, ASM, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, SQL SERVER 2008R2,2012 OEM, Explain Plan, Tkprof

Confidential, Charlotte, NC

Senior DBA Analyst

Responsibilities:

  • Involved in 24x7 support for Production database and applications with on-call pager.
  • Installation and creation of 11g RAC databases for Testing, Development and Production.
  • Supported upgrades from oracle 11g to 12c.
  • Performed migration from 10g to 11g.
  • Supported development, implementation and maintenance of sql server database.
  • Supported migration, and performance tuning on sql server database.
  • Installed and configured oracle 11g RAC for high availability.
  • Data Refresh from Production to Test and Development environments using manual method and RMAN Duplication.
  • Participated in designing and building OEM environments.
  • Proficient in using OEM and grid control.
  • Resolving Performance issues.
  • Performed disaster recovery and provided business continuity plan for development and production environments.
  • Implemented necessary monitoring scripts for Oracle in unix scripting.
  • Performance tuning for optimized results using tools like AWR, SQL TRACE, TOAD.
  • Setup of Standby Database (Data Guard). Performing Failover and Switchovers.
  • Scripts for Cold Backup, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
  • Installation and configuration of Oracle Client software and Tools.
  • Writing UNIX shell scripts for backup and recovery, import and export procedures.
  • Automating the Database Maintenance tasks using PowerShell scripts.

Environment: Oracle 11g R2, Oracle Goldengate 11.2.1, RAC/11g RAC/10g, ASM, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof

Confidential, Framingham, MA

Sr. Oracle DBA

Responsibilities:

  • Apply patches every quarter released by oracle for stand-alone and RAC Instances.
  • Strictly adhere to SLAs defined for Incidents, SRFs and Database refresh from production to Non-production environments.
  • Excellent client facing and presentation skills.
  • CPU patching (EMPTY HOME and IN PLACE) for stand alone, RAC databases.
  • Performance tuning using various tools like OEM, AWR, ADDM
  • Worked on Oracle Binaries Installation.
  • Worked on Database Up-gradation.
  • Worked on User Management.
  • Involved in Space Management and Capacity Planning.
  • Roles, Privileges, space management and configuring database listeners.
  • Monitoring critical grid alerts and alert log for Critical databases.
  • Excellent planning and management of deliverables assigned.
  • Identifying and resolving Locks issues.
  • Creating service request (SR) with oracle support for critical issues.
  • Creating and implementing change requests.
  • Providing 24x7 support and On-call Support.

Environment: Oracle RAC, 11G r2,10G, ASM, AIX, HP-UNIX, Sun Solaris, Red Hat Enterprise Linux, OEM.

Confidential, Wilmington, DE

Sr. Oracle DBA

Responsibilities:

  • Installation of Oracle Database servers.
  • Oracle 10g, 11g Standalone Installations and configuration on AIX machine.
  • Database Migration from source to target using RMAN, EXPDP.
  • Data Pump (EXPDP/IMPDP) Usages for schema backup and refresh.
  • Troubleshooting the issues while installation.
  • Oracle Client Installation on Windows application server.
  • Roles, Privileges, space management and configuring database listeners.
  • Generating AWR report for performance analysis
  • Using OEM console to monitor database.
  • Planning and scheduling backups using Crontab (UNIX) and Scheduler (Windows)
  • Creation of DB LINKS
  • Monitoring and optimizing Performance of the Database
  • Creating and designing schemas as a part of development.
  • Creating, Handling, Closing of SR’s for several issues
  • Creating and maintaining the change record for the migration.

Environment: Oracle 11g/10g, IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, SQL*Plus, Grid Control, TOAD.

Confidential

Software Engineer

Responsibilities:

  • Installation and Configuration of Oracle 10g RAC.
  • Primary point of contact for client for production database support.
  • Performed database cloning to setup test and development database.
  • Used RMAN for backup and recovery. Performed backup validations using RMAN.
  • Proactive database monitoring using 10g grid control.
  • Storage and space management including table spaces and data files.
  • Management of table space growth, monitoring data files additions, extent growth.
  • Upgraded Oracle 8i, 9i databases to Oracle 10g.
  • Applied patches to Oracle Databases.
  • Monitoring Growth of tables and undertaking necessary re-organization of database objects as and when required.
  • Oracle Database monitoring, troubleshooting and resolved the issues.
  • Management of schemas, objects partitioning the tables & indexes.
  • SQL tuning using Statspack, AWR, Explain plan, Tkprof.

Environment: Oracle 10g/9i, IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, SQL*Plus, Grid Control, TOAD

Confidential

Executive

Responsibilities:

  • Provided support for all the databases as an operational database administrator.
  • Installed and configured Oracle 9i databases.
  • Implement Hot, Cold and Logical backup plans.
  • Frequent Database audits to ensure the SOX standards were not violated.
  • Proactive database monitoring using automated scripts.
  • Regular monitoring of batch jobs.
  • Creating and maintaining the change record for the changes that were being made on the Production databases.
  • Maintaining the Light Weight Document Management System.
  • Strong communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

Environment: Oracle 9i, SQL,Windows,Red Had Linux.

Hire Now