EXPERIENCE SUMMARY:

• Confidential, an associate with Confidential since last 12 years in different capacities such Team Lead, SR DBA having a total experience of 15 years and in IT industry as production DBA supported huge Telecom production setup.
• His main area of expertise is as an Oracle 9i/10g/11g database administrator. He is an Oracle Certified, Professional. With Casandra and Couchbase
• Managing and coordinating team in 3 geographic location on shore (USA), near shore(Mexico), off shore (India). Attending Meeting with client and coordination with application team for current project and future Business development. Involved in provide Estimate and design suggestion for various implementation project.
• More than 14 years of experience as Oracle DBA, provided frontline DBA support for 24X7 production, testing and development support on Multi - terabyte 11gR2/11g/10g/9i RAC and Non-RAC databases. First stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels.
• Experience of migrating database from Unix to AIX. Specialize in conversion project Technical designer and Lead for Unix to Linux TEPort conversion.
• Implementation and support Oracle Real Application Clusters (RAC), Including installing cluster ware, ASM (and shared disks) and creating new databases.
• Configuration Setup, Design, Install & Implementation of Oracle 11g RAC, ASM, RMAN / 11g/10g RAC (Real Application Clusters) multiple RAC Node Configuration works.
• Good history of creative, maintainable, and robust application-development solutions using UNIX shell scripting and SQL.
• Experience with GG replication and design and troubleshooting.
• Advanced Performance tuning skills, resolved numerous performance issues, by analyzing trace, AWR reports to identify the bottleneck and use SQL plan baselines, Indexes, and hints to optimize the performance issue.
• Highly proficient in all aspects of Couchbase database and sync-gateway administration including Configuration, Database Security, Backup & Recovery, Replication, DB performance troubleshooting, and Advanced Tuning.
• Authored many UNIX KSH scripts which were deployed over many servers to monitor multiple critical server level and database level events.
• Good experience in Transportable Table spaces, Data Pump, Flashback Table, Table space Management, Materialized Views.
• Migrations from 8i to 9I and 9i to 10g and 10g to 11g. Patches: planning and installing Oracle patches (quarterly) across the Business.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using AWR, Explain Plan, TKPROF.
• Database Installation on HP UNIX, SUN SOLARIS, Sizing, Tuning, Monitoring, DRS Setup and monitoring, Migration from oracle 8.1.7.4 to 9.2.0. g
• Security: follow and implement in house security policies (auditors). Implement high security policies for user accounts, passwords, profiles, role.

TECHNICAL SKILLS:

Operating Systems: HP-Unix, Sun Solaria NT, Windows 2000.Linux

Languages/Technologies: PL/SQL, C,SQL

Databases: Oracle 8i,9i,10g,11g,12 c,Coutchbase,Casandra

Tools: Oracle Enterprise Manager, Data guard, ASM, PL/SQL, RMAN, Toad. Golden gate, Shell scripting, Jenkins

Domain Knowledge: Telecom, Banking, Manufacturing

ENGAGEMENT DETAILS:

Confidential

Database Administrator

Responsibilities:

• Implementation and support Oracle Real Application Clusters (RAC), Including installing cluster ware, ASM (and shared disks) and creating new databases.
• Configuration Setup, Design, Install & Implementation of Oracle 11g RAC, ASM, RMAN / 11g/10g RAC (Real Application Clusters) multiple RAC Node Configuration works. Rman cloning and active active DR setup
• In depth knowledge of Apache Cassandra and Datastax Enterprise Cassandra, read, writes paths and internal architecture.
• Experience with installing, configuring and monitoring Apache Cassandra cluster and implementing multi-datacenter cluster.
• Designing data models in Cassandra and working with Cassandra Query Language (CQL).
• Experience bootstrapping, decommissioning, removing, replacing, and repairing nodes, creating key spaces, tables and secondary indexes in Cassandra
• Experience in Experience in setting up the required replication factors for key spaces
• Highly proficient in all aspects of Couchbase database and sync-gateway administration including Configuration, Database Security, Backup & Recovery, Replication, DB performance troubleshooting, and Advanced Tuning.
• Highly proficient in managing synchronization with mobile devices and also synchronization with back end systems of record
• Involved in designing, developing, tuning, optimizing, deploying and updating NoSQL instances in a high volume transactional environment with critical uptime requirements for a business providing 24/7
• Configured and managed online backup technologies in Couchbase and ensured disaster recovery and data retention protocols (backup, monitoring, security, installation)
• Involved in updating Couchbase dataset and Sync Gateway in a highly available production environment
• Provided on-going performance monitoring and debugging, resulting in a major reduction in downtime due to these issues.
• Documented lessons learned, standards and presented on Data Guard for DBA team, saving team members many hours and improving efficiency in debugging related issues.

Confidential

DBA Team Lead

Responsibilities:

• Attending Meeting with client and coordination with application team for current project and future Business development. Involved in provide Estimate and design suggestion for various implementation project. Leading Teport Migration project of Migrating HP oracle db to Linux. Designs process of migration with full validation of 30 plus TB of online database in less than 6 Hr. downtime.
• Coordination with clients which includes understanding/ gathering requirements (storage /database/budget), supporting vendor installation, resolution of problems and providing database solutions in a timely manner.
• Attending meetings with customer to discuss about current issues and defects in production and give ETA/updates for them.
• Attending meeting with roadmap teams to formulate the Migration roadmap for each Market.
• Implementation and support Oracle Real Application Clusters (RAC), Including installing cluster ware, ASM (and shared disks) and creating new databases.
• Estimating and Validating Hardware & File system requirement & Reviewing high level and detailed designs for future releases.
• Attending meetings with customer to discuss about current issues and defects in production and give ETA/updates for them.
• Attending meeting with roadmap teams to formulate the release roadmap for each release.
• Liaise with development and testing teams for project as well as different systems located worldwide.
• Designed a proof of concept environment to facilitate functionality testing and features, built a pilot environment which mirrored production to do in depth testing for all customers, and provided a detailed migration plan to migrate the current production cluster to the new environments.
• DB installations and upgrades, storage allocation, DB application structures changes, maintaining system security, first level backup and recovery for non-production environments.
• Promote team quality assurance and task cross all activities; Review code/scripts/plans, meet KPIs ad SLA, plan vs. Actual comparisons and LL/RCAs.
• Preparing deployment plan, shift schedule coordinating with all team member, task assignment monitoring, review.
• Identify automation and efficiency opportunities, lead and direct the solution creation and implementation, and assure standards (new and existing processes and initiate enhanced changes).
• Manage and lead Root Cause Analysis, Lesson Learned and prevention processes to meet high standard of deliverables and work according to company methodology.
• Golden gate setup and troubleshooting. Designing Extract Pump and replicate to reduce any Lag.

Confidential

Lead Database Administrator

Responsibilities:

• Coordination with clients which includes understanding/ gathering requirements (storage /database/budget), supporting vendor installation, resolution of problems and providing database solutions in a timely manner.
• Maintaining Oracle Database, Applying Patch.
• Proficient in Oracle Database Design & Administration, Backups & Recoveries, Performance Monitoring & Tuning and Shell Scripting. Good experience in Oracle RAC, ASM, OEM and Data Guard implementation and administration.
• From the performance, tuning prospective analyzing the database frequently to identify the queries having issue and working on fixing the execution time, plan by creating new indexes, using profiles or suggesting changes in the query statements.
• Developing and implementing database backup and recovery plans. Capacity Planning, maintaining space in File Systems and tablespaces, Maintaining Undo and temp tablespaces. Monitoring alert log, memory usage, disk I/O, CPU, database network connectivity etc. Tuning Oracle related kernel parameters, Oracle Parameters, SGA, PGA etc. Configuration, Maintenance and Troubleshooting of Oracle Network files like listener, tnsnames.
• Experienced on Linux, AIX and Unix with Oracle10g/11g/11gR2 RAC (Real Application Clusters), including all options for storage and justifications for deployment.
• DB installations and upgrades, storage allocation, DB application structures changes, maintaining system security, first level backup and recovery for non-production environments.
• Promote team quality assurance and task cross all activities; Review code/scripts/plans, meet SLA, plan vs. Actual comparisons and LL/RCAs.
• Identify automation and efficiency opportunities, lead and direct the solution creation and implementation, and assure standards (new and existing processes and initiate enhanced changes).
• Implemented High availability using Golden Gate Replication& Implanted uni directional replication using various versions of Golden gate

Confidential, Dallas

Senior Database Administrator

Responsibilities:

• Upgraded the Oracle RDBMS and Cluster CRS home with the Oracle-recommended patches and security alert patches
• Well versed in UNIX Shell scripting, database documentation for explanation of various work flow database related processes, SQL scripting.
• Query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Database performance tuning in order to improve application and database performance give recommendation to application team e.g. Index Scan or Full table scan. Run ADDM, AWR report etc.
• Troubleshoot critical issue on call like resolving ORA errors in production, check alert log file, trace file etc.
• Help to design a database and database size and configure Database parameter according to requirements of the application.
• Created (Data guard) physical standby database as DR Solution for production database using RMAN create standby database command, also setup Data Guard Broker to manage data guard environment.
• Worked on Setting up database users, managing database permissions and setting up database roles, and enable database auditing for database security.
• Configured Oracle Change Data Capture on some of the critical batch tables to reduce the run time of many batch jobs significantly.
• Setting up daily monitoring jobs, automatic alert notification when database is down or preset thresholds have been exceeded, installation of new database upgrades, patches, create databases, primary database objects like table spaces, tables, views, synonyms, snapshots, partitioning and sizing tables, indexes etc.
• Performing space estimation and carrying out REORG activities as and when needed.
• Performed regular DBA Activities such as Backups, Modifying Database Structures, Managing Database Storage, Maintaining System Security, Profiles, and Roles.
• Monitored and maintained all production and development databases in a proactive manner to minimize the potential for database outages and performance problems.
• Responsible for Creating/rebuilding indexes, updating dictionary statistics and relocation of the database files to increase performance of database
• Implemented different Partition methodologies to improve performance and manageability of large tables. Implemented partitioning and materialized views for Oracle 10g Databases.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints for the performance tuning.
• Performance Tuning with SQL Command and parameter setting, Index management with index organization. Undo Tablespace management for rollback segment; Rollback segment creation and assignment for transaction as per departmental requirement for process.
• Performing applicative database change management (prod & non prod) while assuring correct alignment to Confidential infra methodologies.
• Ensuring database availability, health, basic performance and assuring first level assistance for SQL tuning.
• Contribute to automation, standards and Database Processes by leading a whole thread activity to his maturity (Documentation, Publication to line) and taking part in modification of existing processes and methods.
• Participate in DB Forums, Triage and Troubleshooting with functional and nonfunctional teams from various SBG and PBG areas ( Confidential and non- Confidential applications).

Confidential

Database Administrator

Responsibilities:

• Undertake Schema creation, object maintenance, space monitoring and created and maintained database objects: tablespaces, tables, indexes, views, procedures, triggers.
• Administered, maintained, developed, and implemented Oracle policies and procedures for ensuring high security and integrity of the company databases (Dev/Lab/Prod).
• Planning and installing Oracle patches on Prod and Non Prod Env.
• Creating Cloning and Maintaining of report database.
• Implementing database change for various product release and new version change.
• Database performance tuning in order to improve application and database performance give recommendation to application team e.g. Index Scan or Full table scan. Run ADDM, AWR report etc.
• Troubleshoot critical issue on call like resolving ORA errors in production, check alert log file, trace file etc.
• Help to design a database and database size and configure Database parameter according to requirements of the application.
• Setting up golden gate replication. generating extract. applying trail and golden gate support.
• Implement high security policies for user accounts, passwords, profiles, roles, privileges.
• Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication
• Setting up environments, access methods, device allocations, validation checks, database Security, user management and database object Management (synonyms, privileges, roles, quotas, table, index, sequence etc.).
• Coordinate with other teams stakeholders to provide DB related expertise and problem solving services to all stakeholders during all project lifecycle (from Development till post production) by clarifying and addressing temporary and permanent solutions to unusual problems

Confidential

Database Administrator

Responsibilities:

• Oracle 8i/9i/10G database installation, configuration, maintenance, backup & recovery and performance tuning in 24x7 environments.
• Maintained more than 100 database including Production, PET, UAT and System test environment via SLA .
• Worked on Setting up database users, managing database permissions and setting up database roles, and enable database auditing for database security.
• Undertake performance-tuning tasks using stats pack, tkprof, etc to ensure optimum running of database systems with minimum downtime.
• Maintaining ST USA db and application of db patch for version release
• Involve in Environment building for PET and UAT, SYSTEM TEST environment.
• Performance tuning of the Database for the Accepted level using Broad brush approach (tuning of Design, Operating system, Database, Instance, Disk I/O and Application); implemented database performance monitoring tools.
• Setting up daily monitoring jobs, automatic alert notification when database is down, or preset thresholds have been exceeded, installation of new database upgrades, patches, create databases, primary database objects like table spaces, tables, views, synonyms, snapshots, partitioning and sizing tables, indexes etc.
• Installation of Oracle software 10g/11g and configure Physical Standby Database for Disaster Recovery.
• Implemented backup and recovery using RMAN in development environment. Documented the process for implementation in production and staging environments
• Created and maintained database objects: tablespaces, tables, indexes, views, procedures, triggers.

Confidential

Database Administrator

Responsibilities:

• Oracle 8i/9i/10G database installation, configuration, maintenance, backup & recovery and performance tuning in 24x7 environments.
• Was involved in determining data feeds required for the BT finance data warehouse, to enable the required reports to be generated.
• End to end development, testing & deployment of database structures, PL/SQL codes in testing and production environments using Oracle advanced replication.
• Undertake Schema creation, space monitoring, Resolving space constraint issues, bottlenecks, and deadlock contentions.
• Setting up daily monitoring jobs, automatic alert notification when database is down or preset thresholds have been exceeded, installation of new database upgrades, patches, create databases, primary database objects like table spaces, tables, views, synonyms, snapshots, partitioning and sizing tables, indexes etc.
• Liaise with BT customers, business units, vendors & third parties. Development and testing teams for SOE DW project as well as different systems located worldwide.
• Undertake performance-tuning tasks using stats pack, tkprof, etc to ensure optimum running of database systems with minimum downtime.
• Design delivery schedule, project allocation, and timelines and liaise with the customer from the start to the delivery.
• Setting up heterogeneous connectivity between Oracle database and Sql server database.

Confidential

Database Administrator

Responsibilities:

• On-site 24x7 DBA / client support and service critical online Banking applications at The United Western Bank Limited (Data center).
• Provided support for primary level debugging (application problems),
• Monitoring database growth and Re-Converted new TC4 branches by loading data.
• Understanding the need of project and creating Database setup accordingly in SDLC.
• Upgrading the database to higher version.
• Performance tuning and monitoring the database using diagnostic tools Like OEM performance pack including Oracle Expert, Lock Manager, Performance Manager, Top Session, Oracle Trace, Table space Manager and V$ views.
• Performance Tuning with SQL Command and parameter setting, Index management with index organization. Undo Tablespace management for rollback segment; Rollback segment creation and assignment for transaction as per departmental requirement for process.
• Performing space estimation and carrying out REORG activities as and when needed.
• Performed regular DBA Activities such as Backups, Modifying Database Structures, Managing Database Storage, Maintaining System Security, Profiles, and Roles.
• Monitored and maintained all production and development databases in a proactive manner to minimize the potential for database outages and performance problems.
• Responsible for Creating/rebuilding indexes, updating dictionary statistics and relocation of the database files to increase performance of database
• Implemented different Partition methodologies to improve performance and manageability of large tables. Implemented partitioning and materialized views for Oracle 10g Databases.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints for the performance tuning.
• Successfully migrated the database from oracle 8.1.7.4 to 9.2.0.6 and also installed Oracle 9i on HP-Unix.
• He is involved in adding datafile or tablespace as per requirement, checking alert log for errors, taking database backup, performing Export and import of data, Performing backend release, Monitoring EOD procedure.

Confidential

Graduate Engineering Apprentice

Responsibilities:

• Involved in managing the physical & logical objects of the Databases,
• Responsible for support, maintenance and administration of Dev, UAT and Prod database.
• Creating and Setting up standby Database and maintaining the replication to make sure databases are available in case of any disaster. Creation of Table spaces.
• Identifying the need and type of backup for the databases. Setting up Backup/Recovery procedure accordingly (Sqlbacktrack or Rman).
• Creation of tablespaces and database objects as per the need of applications teams.
• Performing export/import to support the application team work.
• Cloning of database using hot or cold backup.
• Setting up of Schema with Quota maintenance, performing change management.
• Taking regular backups along with monitoring of physical and logical backup for integrity,
• Oracle installation, troubleshooting on Client and Server connectivity,
• Performing audit of the Database.
• He has contributed in standardization and implementation of the engineering recovery report and also provided DBA support for various reports.