SUMMARY:

• I am a Database Technology, Data and information management leader. I have more than 15 years of experience with Comprehensive hands - on expertise in the Data Architect, Oracle Core, Oracle Exadata, PostgreSQL, No-SQL DB and SQL Server Database Architect and Administration including 6 + years as Lead/Managing Databases Application services, with particular expertise in the field of Data warehouse including Big data. Also, Includes advanced analytics, Data visualization, statistics, business intelligence, enterprise search and Big data related technologies.
• This combination allows me, driving the direction of database technology efficiently. My approach is to embrace both traditional and advanced data management technology to come up with the most efficient solution. Ensure partnering with business leaders to deliver measurable value and influence high-impact of strategic data data-driven decision making. My technical background gives me the ability to be a successful DBA/DW Team Lead as well as an effective IT advocate and communicator with senior and executive management.
• Formulate department wide strategy to improve on processes and streamline existing ones forms part of responsibility and was point of escalation to the management for the DBA and DW team and report to an Executive Director of IT.
• Carried out various project planning and execution, DBA team management, performance reviews, motivational sessions, departmental budgeting, resource management and optimization, cost control and support of over 350 oracle and 200 SQL server databases including 105 plus production databases.
• Experience with Departmental Budgeting, Cost/benefit analysis and project planning.
• Managing recommendations to assist the team in achieving optimum operating capabilities.
• Extensive experience translating business requirements into conceptual, logical, and physical data models. Also leading the Enterprise Data model and performing on-going changes.
• Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation. Includes ETL across different platforms, Sybase to Oracle VLDB databases and flat files.
• Lead and hands-on knowledge of Data warehousing ETL, BI (MSBI (SSIS, SSAS, SSRS), (OBIEE and Pentaho) and OLAP reporting tool.
• Extensive experience on Big Data technology (Cassandra, MongoDB (NoSQL), Spark (Data processing ) and Cloudera Hadoop) also includes Analytics (Tableau, Spotfire, R, Matlab, Python, Minitab and Various other Python Data visualization, and analytics libraries).
• Lead or defined full development life cycle of Data migration (Application release migration) from Release A to B; which include Data extraction, Data massaging (based on new data mapping requirement) and then load into target (B) database, Also DB Migration from Oracle to SQL server using Golden Gate to reduce operational downtime.
• Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation program library maintenance, XML file generation and data quality.
• Principle Technical Lead and define strategy for Installing Oracle 10gR2/11gR2/12c RAC on Various Platforms (Solaris, Linux and IBM-AIX) also including Oracle Data Guard for Disaster recovery solution.
• Primary Database Architect lead on MSSQL Solutions, implemented SQL server 2005, 2008 Cluster failover, Replication and Log Shipping for mission critical systems.
• Leading Database Backup and Recovery Strategy for Oracle,DB2 and SQL server 2000/2005/2008 R2/2012/2014 (ALL=ON)
• Design model and Technical strategy for Maintaining PCI (Payment Card), PHI (Health Information) and PII (Personally Identifiable information) compliance data for Call Center, Medical Device (SJM) and Voice recording Service using RDBMS- Oracle 12c Advance security feature called: Data Redaction and Oracle 11g - Data Masking.
• Configured Oracle VPD and Fine-grained auditing for Medical HIPA compliance data
• Leading System Analysis and Design, Database Design and Data Modeling for Data warehouse system
• Manage various Database project, including technically lead on (VLDB-40TB) Data warehouse system.
• 24*7*365 DBA /Managing support for databases with a large number of users located all over the world.
• Helping development group in prototyping applications.

TECHNICAL SKILLS:

• Oracle 8i, 9i,10g, 12c Professional Training
• Oracle 8i and 9i OCP
• MS SQL server 2008R2/2012 professional training.
• MSBI - 2016 Professional training.
• MS SQL server 2014 Always On and Advance Administration training.
• PostgreSQL Professional Training.
• Python Programming, University of Michigan
• Big Data Analytic Certification, MIT (Massachusetts Institute of Technology)
• IBM- Hadoop Certify Administration

PROFESSIONAL EXPERIENCE:

Confidential, CA

Principle Data Architect

• Leading a team of four DBA and two off site spread across the globe. DBA categorized of Administration, Application, Operation, Production, Change Management, NOC, On-call support and performance optimization.
• Working as Data Governance leader (Performing Overall Data management of availability, Usability, Integrity and security of the Data employed in Enterprise)
• Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.
• Implemented the ticketing system to support Database system 24 by 7 and track the activities for Pro-active approach solutions.
• Managed Configuration Management Databases for IBM’s rational products (Clear Quest & Clear Case) for Defects and ticketing system.
• Facilitated communications with network ops and members of the SCRUM development team.
• Delivered vital consistency through introduction and implementation of enterprise-wide set of database standards.
• Expert level production & development database administration - all platforms.
• Leading and Managing and End-to-end solution of BI success: - Planning and collaboration.
• Managing Data management (Profiling, Cleansing, QA) and Integration Practices(Consolidation, Virtualization and Data Warehousing)
• Modeled database and designed architecture of OLAP layer of BI system and automated the visualization of diverse data sources into customized business reports.
• Defining, designing, developing & optimizing ETL processes for enterprise data warehouse 24×7 supports (including Oracle golden gate and SQL server Replication).
• Managing Current OLTP and ODS DB changes - Data modeling using Erwin.
• Expert level UNIX shell script development for automating ETL processes, data loads, instance data migration & database or file system backup and restores.
• Performed and Leading various Databases integration (Including Oracle, MS-SQL, Postgres and other file system Data) to outcome single source of truth to Business leaders.
• Design Architect and Administration on Data migration of 9 TB DB from Oracle 11gR2 to SQL server 2012 using SSMA and Golden Gate, rest of small DEV DB migration using MS SQL Snapshot replication.
• Design and performed various other Databases (of PostgreSQL) and legacy filesystem migration to Oracle and SQL server: Using Golden Gate, SSMA, SQL replication and PG migration tools.
• Configured and Managing Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC )
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems.
• Design Architect and Configured/managing Active Physical standby Data Guard on Oracle 12c (12.1.0.2) with Advance feature (fast sync)
• Maintaining PCI and PII compliance data for Call Center and Voice recording Service using Data masking and Oracle 12c Advance security feature called: Data Redaction.
• Implemented database firewall and unified auditing for compliance data auditing.
• Managing Oracle 12c RAC (3-nodes of cluster on Linux).
• Currently Managing SQL 2012 (55 Production Databases), Replication and SQL Log Shipping.
• Performed Databases migration from SQL 2008R2 SQL server 2012.
• Principle Architect and Administration on managing SQL server 2014 Always ON (3 nodes -2 sync and 1 async mode (DR))
• Maintaining Traditional SQL server Mirroring for SQL server 2012 (Single node System )
• Configured and Managing SQL server 2016 MSBI ( Data Warehouse DB - 4TB)
• Configured Advance Auditing and SSL certification in SQL server 2012 for compliance Data.
• Performing Various PL/SQL, SQL and T-SQL tuning, also working with developers for explaining them tuning strategy.
• Installed / Configured and managing PostgreSQL V9 databases on CentOS machines hosted in AWS.
• Performing Query offloading to read-only PG DB using slony replication.
• Performed Oracle Database migration (2.5TB) to Postgres using EDB - xDB Replication in minimum oracle production downtime.
• Currently Also managing BDR (By-directional replication/MMR (Multi-master replication) for mission critical databases.
• Working on Hot Standby (PostgreSQL V9).
• Performing system monitoring through EDB - PEM ( Postgres Enterprise manager)
• Maintaining custom vacuum strategies for high volume databases.
• Performing database tuning and using of PostgreSQL tools such as PgBadger and PgStatsPack for EDB.
• Maintaining Professional/Personal commitment to business supporting 24*7*365 DBA responsibilities for Postgres, Oracle and SQ server Databases.
• Maintaining System defined SLA - 10mins for business mission critical Production Oracle and Postgres DB.

Confidential, CA

Principle Database Architect

• Responsible for coordination between our project and support teams and conflict management. High level review of procedures, policies and practices of the DBA and Server team and establishing standards and documenting them are part of my responsibilities.
• Lead or defined full development life cycle of Data migration (Using Agile methodology -Application release migration) from Release A to B; which include Data extraction, Data massaging (based on new data mapping requirement) and then load into target (B) database. Also lead Oracle 10g DB migration to 11gR2 (11.2.0.3).
• Implemented and defined strategy for Oracle 11gR2 new feature called SecureFile for Unstructured (BLOB) data management.
• Define enterprise data architecture vision, strategy, principles and standards; get buy-in from stake-holders, management, business partners, and propagate throughout the company.
• Provide framework, stewardship, governance and decision making for management of data for project development teams, business users and other stake-holders.
• Technical Architect and Lead on Oracle Database HA (RAC) installation and implementation for SAP-ME application also 11gR2 RAC on EXADATA V1.
• Interactions with direct reports, other Supervisors and Managers.
• Extensive experience on leading Database sizing and Capacity Planning.
• Extensive experience on Managing Enterprise Metadata management policy and procedures.
• Balance short-term versus long-term actions, strategic versus tactical requirements, while continuing to move forward towards the strategic vision.
• Configured and Implemented VPD (Virtual Private DB) in Oracle 10g for HIPAA compliance data.
• Implemented Database firewall and Fine grained auditing for Medical Compliance Data.
• Leading the Data masking strategy using Oracle OEM.
• Technical management and Lead on Oracle 11g R2 including 6 node of RAC installation for In house Merlin application
• Leading Data migration team from Oracle 10g (IBM - POWER SYSTEM) to 11g R2 (OELINUX) also 10.5 TB Data migration from Netapp to EMC on Zero downtime.
• Leading ORACLE and SQL server Operational team.
• Define strategy for Performance Tuning of database, SQL tuning for Application
• Leading Various SQL Server 2005 and Oracle Cluster installation.
• Implemented and technical lead on MAA ( Maximum Availability Architecture) interface for mission critical application
• Technical lead on Physical Data Guard in Oracle 10gR2
• Worked very closely with Data warehouse development team
• Technical Lead on Configuring SQL server 2005 Mirroring

Environment: Windows 2003,2008, LINUX, AS3,4,5, IBM x series, Sun Solaris Oracle 11g R1/10g/9i, TOAD, PL/SQL, SQL server 2000,2005 and 2008

Confidential, San Diego CA

Sr. OLTP and Data warehouse DBA

• Implemented the physical data model to adequately manage multi-billion row fact tables using oracle OWB.
• Primary DBA on logical and physical design of DW data model
• Design of master data management architecture
• Estimate System/Database performance.
• Primary responsible for DW dev and production DB backup and recovery
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan
• Define Strategy for Configuring 9i Physical Data Guard.

Environment: Windows 2000, UNIX, IBM-AIX, Oracle 9i/8i, Oracle OWB, TOAD, PL/SQL

Confidential

DBA

• Responsible for the build-out of the oracle infrastructure to support a very large and complex ERP Implementation
• Upgraded production databases from Oracle version 7.3.4 to Oracle 8
• Analysis, development and management of and implementation of in-house Enterprise Computing software and maintenance of existing Software as per the organizational requirement using C++ and Oracle 8
• Provided typical Oracle DBA infrastructure support - installation, tuning, backup and recovery, etc