SUMMARY:

• 20 years of DBA experience managing all RDBMS.
• 10 years of DBA Management Expertise, handling a group of DB Administrators/Developers.
• Technical leadership associated with corporate Database and Storage environment.
• Lead initiatives to implement streamline the best practices and standards.
• Strategic advisor role in long-term planning, geared toward operational excellence
• Capacity Planning, Storage Planning, Disaster Recovery planning, Reorganizing and re-evaluation of Production Databases, and automation of jobs.
• Assisting with Scalability and performance related tasks as needed.
• Helping customers with benchmarking efforts during performance scalability testing/exercises.
• Experience with building, tuning and support large databases OLTP/ Data Warehousing .
• Oracle 7,8i,9i,10g 11g DBA experience on Sun Solaris platform. MySQL 5.5. 5.6
• Oracle Enterprise LINUX OEL , WINDOWS Oracle RAC, ORACLE VM, DATAGUARD, DATA MINER, Application Server, Oracle Grid Server Management, MS SQL SERVER administration, Goldengate Technologies.
• Database disaster and Recovery management using Data pump, RMAN, etc
• Perl, AWK, PHP and Unix, Windows Batch file/shell scripting experience.
• Career activities also include: Data Modeling, DBA activities, Data Conversion, Data Mapping, Systems Management, Data Warehouse Design, and Systems Migration.
• Extensive background in supporting: Managed Services, Development, QA, load testing, and planning data migrations and conversion strategies.
• Extensive Experience in SQL tuning, writing cursors, procedures, and complex queries.
• Solely responsible for the planning and maintenance of Hosted or Managed Services Databases for customers like DELL, SONY, TYCO Electronics etc.

SKILLSET:

EXPERIENCE:

SR.ORACLE DBA MANAGER

Confidential

• Lead the production database team which supports development, validation, and production environments.
• Proactively adjusted schedule of work, priorities, and staffs assignments based on work load to ensure efficient operations.
• Configuration, implementation and production support of OLTP databases on Exadata Quarter racks.
• Installed 2-8 node Oracle 10/11g 11.2g with new SCAN technology, RAC clusters on Red Hat Linux AS 5x/6x using ASM on Dell Powervault SCSI NAS and other NAS/SAN systems to support internal production and test environments.
• Responsible for the configuration and implementation of 2-way replication on Exadata using GoldenGate and DBFS
• Supporting the databases and ensuring their performance, availability and security.
• Defining the standards and checklists, to maintain the health of the server.
• Responsible for Capacity Planning and Resource Planning.
• Develop appropriate polices and plans relating to database backup, recovery, and disaster recovery
• Guided the team to ensure that sufficient hardware resources are allocated to the databases and to ensure high availability and optimum performance
• Proactively monitored the database systems to ensure secure services with minimum downtime
• Providing trend analysis reports to enable management team make informed decisions regarding resource management
• Problem escalation to Oracle Development team and third parties as appropriate
• Improvement and maintenance of the databases to include rollout and upgrades
• Implementation and release of database changes as submitted by the development team
• Understanding and handling applications, helping application groups, troubleshoot application and DB related issues.
• Providing reports on database performance variation and solution.

SR.ORACLE DBA MANAGER

Confidential

• Lead the production database team which supports development, validation, and production environments.
• Proactively adjusted schedule of work, priorities, and staffs assignments based on work load to ensure efficient operations.
• Configuration, implementation and production support of OLTP databases on Exadata Quarter racks.
• Installed 2-8 node Oracle 10/11g 11.2g with new SCAN technology, RAC clusters on Red Hat Linux AS 5x/6x using ASM on Dell Powervault SCSI NAS and other NAS/SAN systems to support internal production and test environments.
• Responsible for the configuration and implementation of 2-way replication on Exadata using GoldenGate and DBFS
• Supporting the databases and ensuring their performance, availability and security.
• Defining the standards and checklists, to maintain the health of the server.
• Responsible for Capacity Planning and Resource Planning.

• Created databases on the Exadata quarter rack. The databases were configured with the Exadata best practices which included huge pages, 4MB extent sizes, partitioning, and SGA target. Ensured that flash cache was being used by using tuning parameters to pin objects.
• Created a 2 way replication between 2 quarter racks using GoldenGate. The DBFS file system was used for the export files. Multiple replicate processes were used to achieve high throughput.
• Develop appropriate polices and plans relating to database backup, recovery, and disaster recovery
• Guided the team to ensure that sufficient hardware resources are allocated to the databases and to ensure high availability and optimum performance
• Proactively monitored the database systems to ensure secure services with minimum downtime
• Providing trend analysis reports to enable management team make informed decisions regarding resource management
• Problem escalation to Oracle Development team and third parties as appropriate
• Improvement and maintenance of the databases to include rollout and upgrades
• Implementation and release of database changes as submitted by the development team
• Understanding and handling applications, helping application groups, troubleshoot application and DB related issues.
• Providing reports on database performance variation and solution.
• Documentation of Standard Operating Procedure SOP
• Working with VT/RFC and ONCALL duties. Taking care of CitiAlerts, CitiBank Online COBL, HCP project

Confidential

Sr. DBA

• Lead the production database team which supports development, validation, and production environments.
• Proactively adjusted schedule of work, priorities, and staffs assignments based on work load to ensure efficient operations.
• Configuration, implementation and production support of OLTP databases on Exadata Quarter racks.
• Installed 2-8 node Oracle 10/11g 11.2g with new SCAN technology, RAC clusters on Red Hat Linux AS 5x/6x using ASM on Dell Powervault SCSI NAS and other NAS/SAN systems to support internal production and test environments.
• Responsible for the configuration and implementation of 2-way replication on Exadata using GoldenGate and DBFS
• Supporting the databases and ensuring their performance, availability and security.
• Defining the standards and checklists, to maintain the health of the server.
• Responsible for Capacity Planning and Resource Planning.

• Created databases on the Exadata quarter rack. The databases were configured with the Exadata best practices which included huge pages, 4MB extent sizes, partitioning, and SGA target. Ensured that flash cache was being used by using tuning parameters to pin objects.
• Created a 2 way replication between 2 quarter racks using GoldenGate. The DBFS file system was used for the export files. Multiple replicate processes were used to achieve high throughput.
• Develop appropriate polices and plans relating to database backup, recovery, and disaster recovery
• Guided the team to ensure that sufficient hardware resources are allocated to the databases and to ensure high availability and optimum performance
• Proactively monitored the database systems to ensure secure services with minimum downtime
• Providing trend analysis reports to enable management team make informed decisions regarding resource management
• Problem escalation to Oracle Development team and third parties as appropriate
• Improvement and maintenance of the databases to include rollout and upgrades
• Implementation and release of database changes as submitted by the development team
• Understanding and handling applications, helping application groups, troubleshoot application and DB related issues.
• Providing reports on database performance variation and solution.
• Documentation of Standard Operating Procedure SOP
• Implementation of CAR Change Activity Reports
• Setup Database Standards development and implementation
• Automation of Database activities and job knowing various tools required in order to do that
• Responsible for using OEM and developing, scheduling jobs, reports, metrics, configuration and installation
• Installation of Oracle, OEM, ASM and configuration, administration.
• Managed the internal and external MS SQL database security
• Additional Skills: Oracle Exadata, OBIEE, PeopleSoft, Oracle Fine Tuning Skills, Oracle RAC, RMAN, Linux Confidential , Oracle Sr. DBA Lead
• Assigned personnel to various projects and directs their activities, reviews and evaluates their work and prepares performance reports.
• Conferred with technical team on administrative policies and procedures, technical problems, priorities and methods.
• Supervised, scheduled and coordinated projects
• Installed and Configured Oracle 8i, 9i, 10g 11g
• Automated Backup and Recovery solutions RMAN , Standby Database, flash query
• Provided Data Modeling support for the development projects.
• Performance Tuning SQL tuning/database tuning : used explain plan, TK Prof, and other tools for tuning the SQL. Used AWR, SQLTXPLAIN, BSTAT/ESTAT and STATSPACK scripts/packages for tuning the database structures.
• Tested Backup and Recovery scenarios using RMAN.
• Familiar with OFA and created OFA compliant Databases
• Performed table and database reorgs for performance improvements.
• Experience in implementing ORACLE replication snapshots/materialized views
• Experience with the High Availability environments RAC fault tolerant and redundant environments Clustering
• Oracle Enterprise Manager both OEM as tool and a WEB BASED portal in 10g . Automatic Monitoring, Administration Notification of Oracle databases, Oracle Applications Servers using OEM, OMS, Intelligent Agent, O/S shell scripting, Oracle DBMS Job scheduling Oracle Alerts. System Administration tasks
• Since it being a product development we used different systems, to develop and test. SAP is also among the software along with ORACLE, SQL SERVER, SAP, MYSQL DB2 on mid range UNIX all types of platform .
• The above software main responsibilities are capacity planning, installation, configuration, patching, monitoring, performance tuning, benchmarking, helping various application teams resolving connection, tuning and administering them in the above respective software

MS SQL SERVER related work:

Supported 4 Production, 1 Staging and 1 Development Server, all were running SQL 7. I understood the entire development cycle for SQL Server Apps, Design Implement - Maintain. Took responsibility of securing all MSSQL Servers by creating logins/users/roles, creating databases, creating indexes, etc. I'm very familiar with Books Online Help and tools provided by Microsoft. Familiar with Replication and Fail-Over Clustering.

Some of the day-to-day tasks involved:

• Nightly differential backups and confirming against the SQL Logs.
• Weekly full backups to tapes.
• Making sure the data is consistent all the time and data integrity is maintained.
• Importing/Exporting of data to and from SQL Server using DTS.
• Create DSN for the users for various applications.

Confidential

Oracle DBA

• Determined user demands, establishes priorities and plans, directs and monitors work.
• Evaluated project status and resource utilization and recommends changes to improve efficiency.
• Installed and Configured Oracle 8i, 9i 10g
• experience with the High Availability environments
• RAC fault tolerant and redundant environments Clustering Standby data implementation
• Oracle Enterprise Manager
• Supported Half a Terabyte size max of OLTP Database.
• Data Warehouse. Created, configured, fine-tuned and supported Data Staging, Data Warehouse and Data Marts. Supported ETL development and wrote PL/SQL scripts for ETL.
• Provided Data Modeling support for the development projects.
• Performance Tuning SQL tuning/database tuning : used explain plan, TK Prof, and other tools for tuning the SQL. Used BSTAT/ESTAT and STATSPACK scripts/packages for tuning the database structures.
• Tested Backup and Recovery scenarios using RMAN.
• Familiar with OFA and created OFA compliant Databases
• Performed table and database reorgs for performance improvements.
• Experience in implementing ORACLE replication snapshots/materialized views
• Population of the Fact Tables by creating complex mappings in Informatica using mapplets and different kinds of transformations like Router, lookup, update strategy etc.
• Creating stored procedures in Oracle to do some aggregates prior to loading the Fact Tables.
• Created workflows and worklets in the workflow manager.
• Installing, Configuring 6.2 Informatica Power Center Repositories.

MS SQL SERVER related work:

• Installing and maintaining the SQL Server 6.5/ 7.0, 2000 Windows workstations.
• Maintaining test, development and production environments.
• Creating and maintaining business analysts, QA, developers schemas, schema objects like views, tables, indexes, synonyms and database objects, data files, rollback segments, extents etc.
• Worked extensively on Microsoft front end tools Visual Basic, ASP , COM, etc. Creating users and privilege management using roles and grants.
• Developing backup recovery methods.
• Tuning the databases parameter files and application code.
• Maintaining Designer repository
• Regular checkup of alert log and trace files.
• Managing growth in data size and users.
• Supporting PL/SQL backend code Packages, triggers for Billing and Stat Modules