EMPLOYMENT HISTORY:

Confidential, MD

Sr. Oracle DBA SME/Database Architect/Exadata DMA

Responsibilities:

• Installed and Configured Oracle DB Enterprise Software, ASM and RAC database instances for Oracle Fusion Middle Ware Applications OIM, OAM and OID (COTS Products).
• Creating and Monitoring databases, Capacity Planning and Space Management, User Accounts Management and Security. Provide support to development, testing and production teams.
• Plan and Co - ordinate the efforts to migrate the Grid Infrastructure, Database homes and Databases from 11g to 12c in Dev, QA, IMPL and Production environments.
• Design and create multi-tenant databases.
• Involved in Researching, designing, analyzing and Deploying Horizontally Scalable Databases using CHARDING Technique for DSH project.
• Manage team for 6 Database Administrators. Resource allocation, Scheduling, SLAs Tracking, On-Call rotation
• Responsible for troubleshooting and fixing Critical HealthCare.gov database performance issues during Affordable Care Act open enrollment periods.
• Involved in migrating databases on VM Ware servers to Oracle Database Appliances (ODA) X3-2 Servers.
• Involved in EXADATA database migration planning and strategy. Migrated Databases from oracle ODA servers to EXADATA X3-2.
• Responsible for tuning Critical Databases, Process and SQLs on EXADATA as per the needs of OLAP and OLTP applications.
• Implemented Exadata features Hybrid Columnar Compression, Smart Scans (Cell Offloading) and Flash Cache.
• Involved in diagnosing and fixing various component failures on EXADATA servers.
• Responsible for applying EXADATA Quarterly Full Stack Bundle Patches on EXADTA Full and Quarter Rack servers in Development/QA, Implementation and Production environments. Responsible for patching all components of the EXADATA ie. Compute Nodes, Cell Servers, InifniBand Switches, Grid Infrastecture Software, PDUs, ILOMs, OJVM, Database Software, Databases and Databases.
• Worked on implementing Disaster Recovery Solution on Full Stack EXADATA at DR site.
• Involved in Data Center Migration Planning and Implementation.
• Plan and Implement the Migration of Standalone databases to MultiTenant Architecture.
• Implement Database compression for archived and online tables for databases on Exadata.
• Install and configure Golden Gate, WebLogic and Golden Gate director tool on Linux Servers.
• Involved designing, architecting and implementing multi-master replication for DR Application stack solution using Golden Gate.
• Designed and developed many critical WAAS Consumer and load PL/SQL procedures.
• Responsible for Designing and Implementing Disaster Recovery Solution for Mission Critical Databases. Created and configured oracle Data Guard databases in Development, Test, Validation and Production Environments.
• Responsible for setting standards and procedures and following up to mentor and train technical staff.
• Responsible for database security and Security audits compliance.
• Architected a failover strategy for EIDM application using Data Guard and Fast Start Failover.
• Support Oracle Fusion Middle Ware Applications OIM, OAM and OID.
• Architected and implemented Backup and recovery strategies using RMAN and ZFS file systems on EXADATA servers.
• Designed and Implemented Oracle Streams solutions to replicate OIM data between across Data Centers.
• Work and co-ordinate with Applications, Production, Operation, change Management, On-call teams and Support External Applications.
• Mentoring and guiding DBA team members in providing solutions to day to day development and operations issues.
• Analyzed and fixed database hang-up and performance issues using OEM, AWR, ADDM reports, setting oracle events and OS tools like TOP, IOSTAT, VMSTAT and SAR.
• Tuned many business-critical SQLs using Tuning Advisors, Performance Advisors, Static Hints, dynamically attaching Hints to built-in Application SQLs, Effectively using Parallelism features etc.
• OEM13c and OEM12c cloud control configuration and administration.
• Setup and Configure OEM to Monitor WebLogic Servers, Oracle HTTP Servers, Application servers and Middleware components, Linux Servers, ODAs and Exadata servers.

Confidential, Riverdale, MD

Lead Oracle DBA/Database Architect

Responsibilities:

• Planned and executed migration strategy for database environment from 9i to 11g.
• Responsible for Work Break Down Structure (WBS), Plan Schedule Management and Resource Planning
• Work with customers, business analysts and technical staff to design, develop and enhance data warehouse components, business intelligence solutions, and procedures.
• Provide technical leadership, setting standards and procedures and following up to mentor and train technical staff.
• Responsible for systems analysis, data definition, data modeling, data architecture, physical database design using ER-Win, data warehouse development, data quality standards, meta data management and database standards.
• Maintenance of data dictionary and/or metadata repositories Mentor project team members in the development of complex data/ETL/BI solutions.
• Installed Oracle Enterprise Software on new AIX Unix Production, Integration and QA/Development servers. Migrated databases from 9i to 11g. Installed and configured OEM Grid and repository. Installed OEM grid agents on AIX servers and configured to be monitored by the central OEM Grid control.
• Creating and Monitoring databases, Capacity Planning and Space Management, User Accounts Management and Security. Provide support to development, testing and production teams.
• Implemented new Oracle 11g features Total Recall, Active Data Guard, Database replay, Transparent Data Encryption (TDE), Tablespace Encryption (TTE) .
• Implemented RAC environment on AIX HACMP clustered file system. Implemented backup policies for RAC environment. Performance tuning for RAC environment. Set up load balancing and TAF. Tuned the RAC environment to balance and optimize the load across OLTP and DW environments.
• Architected a failover strategy for critical applications using Data Guard on IBM P-series servers.
• Responsible for database security and Security audits compliance.
• Migrated database schema changes from Development to Integration Test and Production environments.
• Involved in EXADATA database migration planning and strategy. Migrated Databases from oracle ODA servers to EXADATA X2-2.
• Responsible for tuning Critical Databases, Process and SQLs on EXADATA as per the needs of Hybrid Environment.
• Support Application team, Data Stage ETL team and Business Objects report team.
• Re-engineered the existing Multi-Terabytes data warehouse database physical design to improve the performance and to implement Information Life Cycle Management using Multi-Tier architecture.
• Automated the ILM process using PL/SQL and Shell scripts. Implemented database compression techniques at Tablespace level to implement compression at Partition and Sub-partition level.
• Developed generic shell scripts to backup databases using RMAN and TDP. Installed and Configured RMAN repository and catalogue. Implemented backup and recovery processes using shell scripts and CRON jobs. Monitored the backups and fixed the issues in case of failures.
• Analyzed and fixed database hang-up and performance issues using OEM, AWR, ADDM reports, setting oracle events and OS tools like TOPAS, IOSTAT, VMSTAT, SAR.
• Tuned many business critical Business Objects reports using redesigning the reports, Star Transformations, Query Re-Write and init parameters, Dynamically attaching Hints to SQLs and Parallelism Features.

Confidential, New York, NY

Oracle DBA Lead/Data Architect

Responsibilities:

• Work with customers, business analysts and technical staff to design, develop and enhance data warehouse components, business intelligence solutions, and procedures.
• Created, configured and maintained data guard databases for group application.
• Provided support to many development teams ie. Investments, health insurance, life insurance, share point, CRM and ERP products.
• Architected and implemented replication solution using Oracle Golden Gate between OLTP and Data Warehousing Database.
• Migrated database schema changes from Development to Integration Test and Production environments.
• Design and implement disaster recovery methodology including creation of database backup and fail over jobs.
• Developed generic shell scripts to backup databases using RMAN and TDP. Installed and Configured RMAN repository and catalogue. Implemented backup and recovery processes using shell scripts and CRON jobs. Monitored the backups and fixed the issues in case of failures.
• Interacted with application development teams, involved in data analysis and design. Developed logical and physical models and implemented database changes.
• Analyzed and fixed database hang-up and performance issues using OEM, AWR, ADDM reports, setting oracle events and OS tools like IOSTAT, VMSTAT, SAR, PRSTAT.
• Tuned equity and investments applications using Access Advisor, Segment Advisor, Process Advisor and SQL Profiles.
• Creation and maintenance backup and recovery standards, data architecture, data management standards and conventions, data element naming standards.
• Work as part of a team to provide 7x24 support.
• Retrofit and re-engineered the existing databases using ER-Win.
• Evaluate the critical patch updates and security patches and apply the patches and CPUs as required.
• Analyze critical database issues find the reasons and solutions for the issues and implement the solutions.
• Trained the developers in writing generic, optimized SQL scripts, using indexes, various performance techniques and new oracle features.
• MS SQL Server 2000/2005 administration and maintenance. Install, upgrade SQL Server Software. Architect and configure high availability solution using SQL Server 2005.

Confidential, Baltimore, MD

Sr. Oracle DBA/DW Architect

Responsibilities:

• Creation and maintenance of data architecture, data management standards and conventions, data dictionaries, data element naming standards, auditing the databases
• Retrofit and re-engineered the existing databases using ER-Win.
• Installed Oracle Enterprise software on new Production and development servers, migrated databases from 9i to 10g. Installed and configured OEM Grid and repository. Installed OEM grid agents on 29 servers and configured to be monitored by the central OEM Grid control.
• Configured OEM Grid to monitor 24 production servers and 5 T&V and Development servers and more than 125 databases including many multi TERA Byte and massive OLTP databases.
• Responsible for more than 130 database instances including production, development and test instances.
• Implemented 2 node RAC environment on Veritas clustered file system. Implemented backup policies for RAC environment. Performance tuning for RAC environment. Set up load balancing for RAC by setting up remote listeners and also upgrading to Gigabit interconnect.
• Schedules and coordinates database maintenance activities, acted as liaison between Government TASK Leaders and DBAs.
• Installed and Configured RMAN repository and catalogue. Developed and implemented backup and recovery processes using shell scripts and CRON jobs. Recovered many databases ranged from 50GB to 10TB using RMAN. Monitor backups.
• Created, configured and maintained data guard databases.
• Migrated I/O based databases from Veritas files system to ASM using RMAN.
• Configured ASM to fix I/O bottlenecks on Multi Tera byte databases.
• Created new disk groups, mirrored databases, tablespaces using ASM.
• Involved in Architecting Solaris 10 servers for optimal performance, resource planning and estimations.
• Analyzed and fixed database hang-up and performance issues using OEM, AWR, ADDM reports, setting oracle events and OS tools like IOSTAT, VMSTAT, SAR, PRSTAT.
• Evaluate the patch and security patches and apply the patches and CPUs as required.
• Analyze critical database issues find the reasons and solutions for the issues and implement the solutions.
• Developed many shell scripts to Oracle database maintenance, monitoring, distribute and apply patches, auto starting, stopping database and other process during systems reboot, checking alert log for errors and index and table reorganization scripts.
• Developed generic PL/SQL packages to automate many pre and post ETL processes. Provide support to Microstategy, Cognos, and Informatica ETL teams.
• Implemented Tivoli system to auto start and stop applications before and after Oracle database cold backups. Created Shell and SQL scripts to generate periodic auditing reports of activity on all production databases and corresponding UNIX servers.
• Tuned many complex SQL statements and brought down execution times significantly from few hours to minutes. Performed database tuning by changing init parameters, changing load procedures, distributing I/O and improved the database extract and load process performances significantly.

Confidential, Falls Church, VA

Sr. Oracle DBA/Systems Architect

Responsibilities:

• Developed a failover strategy for one of the critical application modules using Oracle real application clusters on IBM P-series server. Real application clusters architecture was used to satisfy the prime requirements like high performance, better throughput, and high availability.
• Coordinated with application development and testing teams, identified performance bottlenecks and fixed or advised the development team to fix the bottlenecks. Improved performance by at least ten fold in some cases.
• Made suggestions to the development team and documented the process to implement various features of Oracle for performance gain and implemented industry standards.
• Proactively monitor the oracle databases for performance bottlenecks using dynamic performance tables, DBMS packages, Trace utilities and OS utilities.
• Tuned Database I/O issues using Async I/O, DB MUTLI BLOCK READ COUNT, DB BLOCK SIZES, Creating New Indexes, Placing most accessed data files on the inner tracks of the hard disks, properly sizing the DB CACHE SIZE, PIINING the frequently accessed tables in the SGA etc..
• Created shell scripts to automate the installation process.
• Helped development team writing efficient SQL and PL/SQL code. Analyzed and fixed database performance issues using Trace utilities, STATSPACK reports and OS tools like IOSTAT, VMSTAT, SAR.
• Installed and configured Oracle 8i and 9i on IBM P-series AIX UNIX servers.
• Created and maintained users, roles, privileges, tablespaces, data files, and control files, redo log files, parameter file, tables, indexes, stored procedures, functions and triggers.
• Performed basic UNIX system administration tasks including maintaining users, upgrading OS, configuring the network, creating printer queues, configuring the server to create OFA complaint databases, and maintaining backups.
• Provided application knowledge to development team and was involved in development web based module.
• Performed physical and logical data modeling including data warehousing modeling using Oracle Designer 6i.
• Provide 24X7 Oracle DBA and Application on call support.

Confidential, Fair Lakes, VA

Senior Oracle DBA/Production Support

Responsibilities:

• Apply comprehensive business processes, application design and functional knowledge in problem resolution.
• Tuned the databases and applications to effectively use the CPU, Memory and I/O. Used application knowledge and SQL hints to dictate execution paths and tremendously saved the resource usage and execution times.
• Fine-tuned PGA AGGREGATE MEMORY by setting up PGA Advisory and also involved in tuning DB CACHE SIZE by setting up Buffer cache Advisory Involved in Capacity planning.
• Performing evaluations of potential tools and utilities.
• Automating database tasks using shell scripts, OEM and PERTOL monitoring tool.
• Updating, migrating, and refreshing database environments.
• Configuring monitoring and proactively reviewing statistics for errors, capacity and performance issues.Tuning and troubleshooting software & database performance issues.
• Re-organized the tables and indexes using EXP/IMP utilities and other techniques.
• Ensuring database recoverability within the constraints of any application, project and other requirements.
• Used clarify to track problems, issues and resolutions. Used Clear Case to version control the software.
• Coordinates and participated in database stress tests, analyzes results, and makes recommendations for design or coding changes based upon those results
• Provide 24X7 Oracle DBA and Application support.

Confidential, Raritan, NJ

Oracle DBA/Systems Architect/Team Lead

Responsibilities:

• Served as senior Application and Database architect and technical lead. Responsible for systems analysis, design, development, database administration and system administration. Responsible for investigating, recommending and implementing all new database technologies and Oracle license management.
• Performed IBM/RS6000 Unix system administration.
• Architected Client/Server database application and involved in complete system development life cycle of the application.
• Developed implementation plan and involved in implementing the software to be used at 39 regions and 9 national testing laboratories across USA.
• Trained technical personnel to configure and maintain the software and the databases to be used at all regions and national test laboratories.
• Coordinates and participated in database stress tests, analyzes results, and makes recommendations for design or coding changes based upon those results
• Developed tools using SQL, PL/SQL and shell scripts to version control validation data and DDL.Designed and developed front-end screens using Oracle Forms.
• Architected and developed data warehouse solution using Oracle replication techniques and PL/SQL packages. Provided technical specifications and designs to development team.
• Involved interaction with customers, requirement collection, system analysis, design, physical, logical data models, process diagrams, and hierarchical diagrams, writing technical specifications, SDD, development using Designer/2000, developer/2000 and requisite/pro.
• Installed and configured Oracle, SQL *Net and multi-threaded environments. Ported applications from HP-UX to AIX Unix.
• Involved in complete SDLC of business process re-engineering. Created logical and physical relational data models for all new modules using Designer/2000. Created process diagrams, hierarchical diagrams, data flow diagrams, ER Models, data diagrams as part of physical and logical modeling and analysis using Designer/2000 and Erwin.
• Involved interaction with customers, requirement collection, system analysis, design, writing functional and technical specifications requisite/pro.
• He tuned database and application performance by using SQL *Trace, TKPROF, Explain Plan, UTLBSTAT, UTLESTAT, SQL Scripts and Unix Utilities SAR, TOP, iOS tat, lsps, and SMIT.
• Ported applications from Oracle 7 to Oracle 8. Trained application users and administrators, and installed and configured databases for development, training, testing and documentation divisions.