SUMMARY

• Over 13 years of experience with Oracle database management (11 years as a Database Administrator).
• Experience with Oracle installation, database creation (Oracle version 11g/10g/9i/8i/7x databases), experience in writing stored procedures, functions, packages, triggers using PL/SQL, performance tuning ( instance and query level), Oracle replication, change data capture (CDC), Oracle Clusterware and Oracle RAC, Data Guard and ASM administration.
• Routine tasks that I handled include fulfilling daily support activities e.g. Security management (user creation, assigning privileges, roles, managing quotas, implementing security audits and recertification of user ids etc.), capacity planning, monitoring (using OEM Grid, alert log, CPU, memory, I/O, database network connectivity).
• Experience in supporting OLTP (online transaction processing) as well as reporting/data warehouse instances and tuning Oracle instance components, memory configuration, wait events. Detecting and diagnosing production system performance problem by analyzing Oracle and system trace file, analyzing SQL statements, measuring system and database activity using querying Oracle dynamic performance views and OEM grid control; tuning database and applications, optimizing initialization parameters and operating system variables, I/O distribution and striping, shared pool and buffer cache optimization, monitoring locks and enqueue contention, SQL statement tuning using SQL Tuning advisor, TKPROF, SQL Trace and EXPLAIN PLAN tools.
• Experience in migration/upgrade of Oracle databases to higher versions, database cloning (RMAN duplicate and cold refreshes).
• Identifying performance bottlenecks on high volume transaction systems. Reorganizing database objects and rebuilding indexes to improve response time of queries.
• Configuration, maintenance and troubleshooting Oracle network files e.g. listener.ora, tnsnames.ora. Assisting developers in getting database connection from the client using SQL *net.
• Have experience with designing and developing application schemas, ER diagrams, tables, indexes, database triggers, PL/SQL code and other DB objects to support front end applications. Working closely with developers and providing Oracle DBA support and technical support for multiple applications in development, integration and production and QA environments.
• Experienced in writing Functional Specification and System Technical Design documents.
• Adept in mastering new applications, technologies, 3rd party applications and adapting to existing corporate infrastructures, producing effective results in cross - functional IT roles.
• Able to work independently and collaboratively in Team environment. Good interpersonal, communication skills along with technical, documentation, research, general business and functional skills.

TECHNICAL SKILLS

Operating Systems: Solaris, HPUX, AIX, Linux, Windows NT/XP/Vista

Languages: SQL, PL/SQL, Pro*C, PERL, PostgreSQL, UNIX shell scripting.

RDBMS/Packages: Oracle 11g/10g/9i/8i/7.x, SQL*Plus, SQL*Forms 3.0, Reports 2.5, Microsoft SQL server 2008 R2

Tools: SQL Plus, SQL*Loader, Borland StarTeam 2005 Client, Oracle Enterprise Manager (OEM), TOAD, SQL Navigator, Erwin Data Modeler Rel7.2, Mercury Win Runner, Load Runner, PVCS Tracker, Crystal reports 10, Microsoft Visual SourceSafe 6.0, Remedy, HP Open View service desk.

PROFESSIONAL EXPERIENCE

Confidential, Shelton, CT

Senior Oracle DBA

Responsibilities:

• Designing, testing, implementing, maintaining and controlling the organization’s data bases, working closely with technical and client management to design and implement data bases and data base support tools in support of complex business application development requirements and processes.
• Implemented OEM grid control for monitoring database, servers and other related targets (completed installation of OMS software, creation of repository and installation of management agent on servers).
• Developed OEM grid control standards, templates, guidelines and best practices
• Working as a performance engineer to work on all the performance related database issues. In addition, working with the whole team to find proactive methods/tools to improve database/system performance.
• Monitoring transaction activities and assisting in the utilization of data bases.
• Maintaining the integrity and security of data in master files.
• Assisting in the development of standards and procedures affecting data base management, design and maintenance.
• Mentoring & helping junior members and the offshore team to increase the overall efficiency & productivity of our group.
• Establishing and maintaining databases for user tests and production purposes.
• Creating/updating service catalog for all DBA services offered by the team.
• Performing other related duties as assigned or requested.

Confidential, Hartford, CT

Oracle DBA

Responsibilities:

• Design, implement and monitor database functionality to ensure stable environments
• Perform database administration and management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments
• Uphold enterprise policy guidelines and recommend new and improved guidelines to ensure compatibility and better service for end-users
• Identify and initiate resolutions to user problems/concerns associated with database server equipment (hardware and software)
• Identify potential service level problems before they occur and notify appropriate parties
• Stay abreast of the most current release of Oracle, including compatibility issues with operating systems, third party software and utilities
• Test and evaluate new products as relevant
• Log support cases as necessary and effectively work with Oracle Corporation
• Maintain up-to-date plans for disaster recovery and fail over capabilities and test as required
• Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects
• Propose solutions, identify tools, and generate procedures to ensure an efficient, consistent repeatable environment
• Use and deploy RDBMS software, data management tools and utilities, data warehouse and replication tools
• Maintain security according to best practices and generate security solutions that balance auditor requirements with user requirements
• Participating in 24x7 on call rotation.
• Supporting RAC databases with 2 nodes, 3 nodes clusters and ASM (automatic storage management).
• Supporting and maintaining logical data guard.
• Database monitoring using grid, creating databases, scheduling backups using Autosys, Cron, implementing database patches.
• Backup (full, level 0, level 1, legal) monitoring, archive log space monitoring, alert log monitoring, tablespace monitoring.

Confidential, Windsor, CT

Oracle DBA, Data Architect

Responsibilities:

• Supporting weekly, monthly releases, release management process and data models.
• Setting up of environments, access methods, resource allocations, validation checks, database security and auditing, user management and database object management.
• Implementing scheduled code promotions, emergency fixes for Oracle, managing and maintaining UNIX shell scripts.
• Supporting PL/SQL code rollout, data fixes, working as a part of team in 24x7 production environments and providing on-call support on pager and day-to-day support.
• Responsible for maintaining security and generating audit reports for database changes in production environment in compliance with SOX.
• Designing data models, logical databases, physical databases and schemas. Assisting in systems planning, scheduling and implementation. Installation, upgrading, applying patches and testing of databases and other database based software. Enforcing data integrity constraints on the tables in accordance with data model. Updating data models for various modules and applications.
• Providing support for implementing and upgrading various new and third party applications.
• Performance tuning of SQL statements and database using tools like SQL Trace, Explain plan, TKPROF, STATSPACK and various data dictionary views etc.
• Managing database structure, storage allocation, table/Index segments, rollback segments, undo segments, and constraints, involved in capacity planning.
• Securing the information by de-identifying and masking the Personally Identifiable Information (PII) for the databases and distributed environment applications. De-identifying the PII data elements in all the categories (standalone, complex etc.), reducing the amount of PII collected and saved on company systems. Participated in proof of concept (POC) for implementing the same in production environments and evaluated tools (home grown tools Vs Exeros) for the same. Providing consistent and repeatable processes to ensure existing and future non-production environments remain clean of PII data. The various steps followed were analyzing, prioritizing, de-identifying, verifying and operational implementation.
• Preparation of technical requirement document (TRD).
• Effort and space estimation for data model changes and other support activities.
• Reviewing/auditing new application components to determine acceptability for inclusion into production. Reviewing systems under development and related documentation. Participating in the installation of new and/or updated systems software through pre-production environment. Liaisons with database software vendors and external technical support personnel on issues such as software upgrades, problems and potential solutions.