SUMMARY:

• Extensive experience in IT with more than 20+ years in Oracle / SQL database (OLTP/DSS) administration including Distributed, N - Tier, Parallel and Replication Servers and Application Servers, Data warehouses and using ETL Tools.
• Designed and developed Relational Data Models and implemented on Oracle/SQL servers.
• Extensive experience in managing large Oracle databases on all major UNIX variants, MS and Linux platforms with local and enterprise storage solutions (both SAN and NAS).
• Extensive experience in setting up physical and logical Data Guard, Partitioning, Advanced Replication, Oracle Streams, Real Application Cluster, Recovery Manager (RMAN).
• As a production DBA, dealt with Operational Support, Physical Database Design, High Availability, Security, VLDB, Real-Time OLTP and Monitoring of Mission Critical 24x7 Databases.
• Strong experience on Oracle 12c/11g RAC on Sun Solaris & Linux AS 4 platform with ASM.
• Well versed in the following data domains: Master Data, Operational Data, Analytical Data, Unstructured Data, and Metadata.
• Strong experience in AWS, Cloud computing, Big Data, Data Virtualization, Data Integration Technologies, Hadoop Technologies and tools like Hive, Cloudera, Pig Script, Python, Spark, Flume, and other related technologies
• Extensive experience on implementation of high volume OLTP & OLAP database systems.
• Experience in setting up operations / support teams providing 1st, 2nd and 3rd level day to day Operational support and developing business continuity plans.
• Facilitate review of risks & development of risk mitigation plans, implementation of DR across multiple geological regions.
• Enforced policies, standards, and guidelines regarding databases, database development and management to comply with HIPAA, SOX.
• Strong skills in UNIX & perl shell scripting.
• Application expertise includes Data Warehousing, Data Modeling, ETL Designing.
• Competent in Information Life Cycle Management, SDLC and Project Development Life Cycle.
• Interact with vendor support to ensure open issues are resolved within defined SLA
• Strong expertise in problem solving, decision-making, management skills, leadership skills.
• Certified Scrum Master ( SMAC)
• Oracle Certified Professional (Database Administration)

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i/8i/7.x, Oracle RDB6/7, Teradata, Exadata, MS access, SQL Server, MySQL

HDFS: Big Data, Mongo DB, Cloudera, Hive, Pig, Sqoop, Flume

GUI Tools/IDE: OEM12c/11g, Oracle Developer, X-Windows/Motif, HTML

Data Warehousing & OLAP: Business Objects, Cognos, SAS, SSIS, SSRS

ETL Tools: Informatica (PowerMart, PowerCenter )

Middleware: TIBCO IM/MessageBroker/ActiveDatabase Adapter, Oracle Fusion

Data Mining Tools: IBM Intelligent Miner, Business Miner, DataMirror

Data Modeling & Use: Cases Oracle Designer, Erwin

Tools: MS Project, Visio, MS Office Suite, Jira

Automation tools: HP DMA, Bladelogic, Ansible

Cloud: AWS, Azure, EC2

PROFESSIONAL EXPERIENCE:

Confidential, Thousand Oaks, CA

Sr. Database Consultant/ Architect

Responsibilities:

• Consolidated/ migrated data centers from RI, WA, CO & CA into shared datacenter as Las Vegas, NV thereby reducing over 1400+ Oracle database instances into about 680 instances providing better reliability, availability, scalability & manageability (RASM).
• Working as team lead to improve Oracle database performance/ uptime, for implementing the best methodologies for re-engineering efforts, and implementation of those reengineering efforts to ensure scalability.
• Responsible for managing service requests, participating in change review & weekend planning sessions, interfacing with Operations and Production Support and meeting with Data Management customers.
• Other responsibilities include directing team members through the analysis and resolution of problems and issues, and conducting follow-up meetings to determine root cause analysis and prevention.
• Performance tuning; troubleshoot issues related to migration; DB cloning, setup of data guard; Installation of Oracle 12c.
• Installed and upgraded Oracle Servers, Monitoring space requirements and adding new storage space. Monitoring and tuning database to ensure optimal performance. Handling database backup and recovery using RMAN. Implementing schedules for database backups.
• Used Netapp SnapManager for fast & efficient Oracle Backups. Configured Netapp pools storage resource for optimal I/O performance. Wrote Netapp scripts for automation & db cloning.
• Developing database processes and procedures for overall Database Operations, upgrades and maintaining IT processes, production controls, capacity planning, system backups and recovery.
• Installation & configuration of OEM 12c for monitoring & automation of jobs.
• Automation of OS and database patching & software install using DMA.
• Worked on evaluation of various Cloud computing technologies, Big Data, Hadoop Technologies and various distributed computing solutions based on Hadoop tools like Hive, Cloudera, MongoDB, Spark, Flume, and other related technologies.
• Currently working on strategies to migrates databases to AWS RDS & EC2, automate server builds on Amgen CloudOne.
• Configured Oracle Gateway for connections from Postgres, Cloudera and SQL Server.
• Providing technical and functional guidance to the corporate planning and decision making process. Define and enforce standards, best practices and disciplines relating to Database Management and Architecture.
• Handled responsibilities to implement BI solutions/ Data warehouse projects. Managed workloads, analyze requirements, assign dedicated resources to meet requirements for reporting, analysis, and implement data warehouse solutions.
• Responsibilities include entail defining, developing, implementing, measuring, and improving all processes, procedures, and activities required to ensure accuracy and quality of reports and data validation.
• Evaluated, integrated & implemented various Commercial-off the shelf (COTS) systems.
• Translated business requirement into cost effective high level design components for the developers to develop their low level design.
• Review all project level design documents to ensure that the business requirements, design standards are adhered to, created data repository for reporting and mapping purposes.
• Worked as Release Manager to deploy/ upgrade several new applications within a specific timeframe. Was one of the primary interface managers working with the development groups making the build process more transparent during the Release life cycle phases.

Confidential, Camarillo, CA

Database Architect

Responsibilities:

• Providing technical and functional guidance to the corporate planning and decision making process. Define and enforce standards, best practices and disciplines relating to Database Management and Architecture.
• Supporting several critical databases in a Veritas Cluster (VCS) & RAC on Solaris, Linux, for 24x7 uptime and high availability.
• Providing technical consultation on moving Oracle databases currently running VCS configuration to Oracle RAC on Lintel farm.
• Implemented Oracle11g RAC on clustered machine under Solaris Sun Cluster and Linux.
• Installation, configuration and troubleshoot issues for Oracle 11g/10g RAC database on Solaris and Linux boxes and 11g/10g Application server SOA suite on Linux AS4.
• Administration of OLAP/OLTP Oracle databases. This includes large numbers of concurrent users management, response time constraints, data is accessed both read and write, continuous uptime, heavy I/O, heavy use of roll back segments and large amount of memory, tuning Oracle parameters around this to optimize performance and performing logical and physical reorg to improve database performance.
• Worked with apps teams for minimizing down time for database & storage filer migrations.
• Interview, brainstorm and document the L2 & L3 processes, own OPS manual and create awareness through training sessions, FAQ, quizzes, and workshops.
• Finalize requirements for SLA measurement, and reporting.
• Installation & configuration of OEM 11g for monitoring & automation of jobs.
• Database upgrades/patches, application upgrades, database moves.
• Implemented VPD policies for fine grained access.
• Configuration and troubleshoot issues for Oracle GoldenGate replication.
• Defined database security standards for complex physical databases across multiple platforms, technologies and computing environments.
• Responsible for providing and insuring data availability, data integrity, and data security.
• Conducted Sprint-solving meetings with the Product owners and provided new directions in addressing the release backlog problems while simplifying the team’s level-of-effort estimations used in selecting the right numbers of developers/testers with the right skill sets at the right time.
• Provided ways to measure a project’s backlog planning and its progress while avoiding scheduling constraints, slack time issues and deliverable problems.

Confidential, Woodland Hills, CA

Senior Database Administrator

Responsibilities:

• DBA activities - Logical/ physical design of databases, maintaining system security, defining of roles, profiles etc., backups, performance issues, connectivity to database, creation of database links, upgrade strategies, capacity planning & tuning of ORACLE parameters.
• Installation, configuration and troubleshoot issues for Oracle 10g / Oracle10g RAC database on HP-Ux & Solaris boxes and 10g Application server SOA suite on Linux AS4.
• Design and implement tuning strategies and backup plans for databases.
• Enhanced database security, implemented alert warning methods, and maintained production & non-production equivalent environments.
• Wrote scripts for generating logs & alerts for optimal database performance.
• Extensive experience in managing large Oracle databases on all major UNIX variants, MS and Linux platforms.
• Installed and upgraded Oracle Servers, Monitoring space requirements and adding new storage space. Monitoring and tuning database to ensure optimal performance. Handling database backup and recovery using RMAN. Implementing schedules for database backups.
• Developed recovery procedures for each database, making sure that the backup schedules meet the recovery requirements. Managing database users and security, establishing and enforcing standards, setup and maintain data replication, server scheduling and work with development teams.
• Worked on Oracle RDB to Oracle10g migration efforts.
• Worked in environment support team to build, facilitate data & code refreshes required for development teams.
• Handled responsibilities of design, implementation and maintenance of database for Data warehouse project.
• Wrote scripts for complete data load, updates and refresh cycles into Data warehouse involving steps for data cleaning, transformations using SQL Loader and PL SQL scripts.

Confidential, State of California, Sacramento

Senior Database Administrator

Responsibilities:

• Worked as Production Database Administrator.
• Prime responsibilities for all DBA activities - Logical/ physical design of databases, defining of roles, profiles etc., backups, performance issues, connectivity to database, creation of database links, upgrade strategies, capacity planning & tuning of ORACLE parameters.
• Formulated upgrade strategy. Performed migration of entire system from DEC to Sun Spark machine
• Provided necessary upgrades required for integration with old COBOL system being used at common Government Data Center by various other agencies.
• Did System Study, Analysis & Prototyping. Designer 2000 was used extensively for the purposes. Reviewed and reformed the Function and Information model for the system.
• Customized Oracle Financials 10.6SC - HR and Project Accounting modules.
• Supervised the entire software development process.
• Coordinated with other government agencies accessing the data.

Confidential

Assistant Manager (Systems)/Database Administrator

Responsibilities:

• Installed and administered Oracle7.1 and upgraded to Oracle8. Provided expert solutions to all data and database related activities including logical and physical design capacity planning, software selection, installation and maintenance.
• Implemented business logic in stored procedures, packages and customized and supported Oracle Financials Application modules.
• Has been a team lead of DBAs in administering a group of Databases of 300+ Gigabytes apart from Test databases responsible for maintenance and monitoring continuously for performance and tune periodically to optimize performance and also prevent slowing down.
• Responsibilities include Database Maintenance and performance tuning of Financial accounting, Sales, Distribution, billing and servicing databases, Writing Stored procedures and triggers. Identifying the current reporting requirements of the enterprise and understanding the business process for a Paper/Cement/Tire manufacturing Company.
• Responsible for Migrating databases to a high availability configuration; featuring 0% down time, Oracle STANDBY database and online (hot) backup design with 99% availability. Provided 7-x 24 on-call support.
• Responsible for maintenance and guidance in troubleshooting/fixing Oracle Servers databases (ver. 7.3 and 8) and Administering UNIX Server.