SUMMARY

• Highly result - driven Manager, Senior Database Administrator and Developer with demonstrated success in Administration, Installation, and Maintenance of multiple Clustered and Non Clustered Oracle and SQL Server databases on Unix, Linux and Windows environments for OLTP and multi-terabyte Data warehouse databases.
• Primary responsibilities include Core Configuration, Install, Maintain and support Oracle 9i/10g/11g/12c RAC on Exadata and Virtualized Servers
• SME in Oracle Engineered Systems; Super Cluster T 5-8, Exadata X5.X3,V2 Appliance Machine acquisitions, Configuration, Deployment, Data Migration and maintenance of storage servers and databases
• Assess, Manage and Architect comprehensive portfolio of database security to ensure data privacy, protect against insider threats, and enable regulatory compliance for both Oracle and non-Oracle Databases and deploy reliable data security solutions that do not require any changes to existing applications, saving time and money in all areas of Data Masking, oracle Advanced Security (Encryption), Oracle Database Vault, Oracle Audit Vault, Oracle Database Firewall and TDM (Test Data Management) using Delphix, CA, Storage Snap Cloning, Data Subsetting, Familiarity with Security Tools, Oracle Advanced Security ad IBM GuardiuM
• Manage and Lead HA/MAA solutions for Clustered and Non Clustered Oracle RAC, Non RAC and SQL Server 2008, 2012 databases.
• Expertise in Database Replication Technologies, Oracle Standby/DataGuard Environments, SQL Server ALWAYS ON using Availability Groups AGs
• Expertise in Construct of Data Models, designed schemas for multi-terabyte OLTP and Data Warehouse Environments

TECHNICAL SKILLS

• Oracle SuperCluster T5-8, Exadata X5-2, X3, v2, Database 7.X/8.0/8i/9i/10g/11g/12c RAC and NON RAC database on Sun Solaris, AIX, Windows and Linux platforms
• Oracle Data Gurad - Logical and Physical Standby, Golden Gate for Replication, Oracle Grid Computing, Delphix 4,5 Oracle Business Intelligence 10g/11g (OBIEE)
• Peoplesoft 8.2, Oracle Application Server 9I 1.0.2.2\8.2, Oracle APEX,J2EE Architecture, OC4J, ODBC, JDK 1.4, Java 1.3, JSP, Java Beans, Struts Framework
• JavaScript, HTML, JDeveloper 9i, Macromedia Dreamweaver MX 2004., SQL/PL SQL, Toad, SQL Navigator, SQL Server 2000, 2005, 2008 2012 Enterprise and standard.
• Data Modeling Tools Erwin, Power Designer
• Sun Solaris 11, Oracle ZFS 7320, Exadata MPP X5-2 LPARs, IBM SAN, EMC SAN, RAW Devices, LDAP
• Strong AuthenticationData warehousing, OLTP, DSS,, Replication, Network Attached StorageASM, VLDB, HTTP/S, Load Balancing, Data Warehousing. Oracle Streams

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Senior Consulting Resource tasked by Corporate Database Compliance and Security to assess the Database landscape areas, Enterprise Architecture and practices in maintaining the current implementation of database security solution using IBM Guardium across North America, Russia, China, Asia Pacific regions and create an POC to Implement Oracle Audit Vault on ExaCC environment including database migration plans from 11g to 12c.
• Finally, to construct plans to achieve findings derived from observance, working with the team and personal work experience in the context of being an experienced database administrator that has leveraged traditional database technology stacks and also engineered systems such as Exadata, SuperCluster and other Oracle Database Appliance.
• Develop and coordinate infrastructure implementation and database migration to consolidate approx. 300 plus databases in MultiTenent 12c environment.
• Implement Oracle Unified Auditing on SoX and Secret databases, develop and create customized policies comparing to sniffed traffic on IBM appliance.

Confidential

Lead DBA/Developer

Responsibilities:

• Lead and manage Enterprise Exadata X6-2 Engineered System Acquisition and Implementation
• Lead Enterprise level Customization of Super Cluster, I/O Domains, Data Domains for Production, Test, Development and BCP Solutions
• Install, configure, maintain and patch Oracle 11gR2 and Oracle 12c RDBMS, RAC, and ASM.
• Migrate the Oracle PeopleSoft Database Environments to Exadata Platform.
• Assist in Production databases cutover to Exadata.
• Create standby failover databases at the Albany Data Center using Oracle Data Guard.
• Add each database as a target in Oracle Enterprise Manager 13c.
• Implement database options Data Masking, Real Application Testing, and Advanced Compression in OEM and the specified database environments.
• Configure TNS SCAN listeners as needed.
• Implement RMAN backup, recovery and clone procedures in the new EMC Avamar environment.
• Troubleshoot database-related issues where necessary.
• Develop and maintain shell scripts to manage Oracle services where applicable.
• Perform verification testing and complete all related types of documentation.
• Coordinate activities with the follow DBAs, Network, Security and Applications groups.
• Implement, Install, Configure Oracle Advanced Security tools

Confidential

Lead DBA/Developer

Responsibilities:

• Manage Enterprise Oracle Super Cluster x-5 - Exadata Engineered System Acquisition and Implementation
• Lead Enterprise level Customization of Super Cluster, I/O Domains, Data Domains for Production, Test, Development and BCP Solutions
• Capacity Planning for Migrating 11g & 12c databases to Oracle RAC Clusters on Exadata
• Work Independently to Plan, Coordinate and Facilitate Oracle Vendor in all Full Life Cycle of Hardware acquisition and implementation
• Developed and worked with development teams for creating database packages/Procedures/functions to enhance and automate business logic in OLTP high transactional databases
• Expertise in Performance Tuning using OEM, SQL tuning Sets, profiling, SQLT utility and Trace File Analyzer
• Lead and manage Grid, Cluster ware, RAC database health checks using Oracle tools such as OraCHK, ExaCHK, CVU, Cluster Health Advisor and Monitor and Hang manager.
• Hands on using Oracle Golden Gate 11g,12.2 Unidirectional/Bi Directional Classic & Integrated Capture methodologies
• Successfully Implemented Delphix 5 on Exadata Stack on ZFS appliance for Test Data Cloning with Configuration for daily SnapSync & LogSync with multiple Schedules
• Implemented Data Virtualization Methodologies to Configure and Refresh Delphix and Exadata Technologies for TDM, approx. 20 VDB’s with Data Masking.
• Lead Enterprise level Test Data Management TDM implementing and provisioning for Oracle 11g,12c including Pluggable databases using Storage Snap Clone on Exadata using Snap Clone on Sparse Disks creating Test Master with Data Subletting and Masking
• Hands on 24x7 in Platform Migration, Data conversion, and testing to validate the success of migration
• Work Independently to Lead, Cross Train, and mentor other DBA’s, Developers and Off Shore teams
• Lead the DBA team to implement BCP and Data Guard Solution at remote side using multiple Oracle Cascading Standby Configurations
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Integration of Exadata sever monitoring and escalation into existing database security monitoring and actionable events solutions using Oracle TDE and Oracle Audit vault for database Monitoring
• Testing and benchmarked the applications prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• Hands on using SQL Server 2012 ALWAYS ON

Confidential

Database Consultant

Responsibilities:

• Collaborate with clients for Implementation and Deployment of Oracle ODA Environments Exadata X3 and V2 Oracle Engineered Systems
• Work closely with Executives for Exadata Systems Acquisition with Oracle Corp, Infrastructure Configuration to meet internal security requirements
• Integration of Exadata Monitoring and Performance and Tuning recommendations and documentation
• Advise, provide guidance and Develop Disaster Recovery Strategies for these Database Machine
• Lead in Test Data Management in downstream environments, to architect data movement and provisioning using complex business rules adhering to standard and policies.
• Act as Advisory to Data Management Teams for data discovery & analysis, data acquisition WRT Data System, archiving and recovery strategy, load strategy design and implementation to downstream environments and optimization
• Perform Oracle Data Masking on Multi TB database, Data sub setting and partitioning on OLTP and Data Warehousing Databases.
• Lead in Configuring Multi node RAC Database & troubleshooting the cluster databases & maintaining RAC Instances
• Actively involved in installation and heath check of Grid, Cluster ware, RAC database health checks using Oracle tools such as OraCHK, CVU, Monitor and Hang manager.
• Tune RAC instances using AWR/ADDM, SQL Trace, Explain Plan and sql profiling
• Lead Data Masking Efforts with onsite and offshore teams for obfuscating PII information from multiple data sources Utilized Oracle Data Masking 12c Pack
• Migrating from DB2 to Oracle Exadata: using External Tables, DB Links and Golden Gate
• Hands-on experiences in installation, configuration, performance tuning and troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments
• Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c
• Used DataPump for filteririg using Parallel Extracts ad Parallel Replicats
• Experiences in setting up Oracle GoldenGate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in RAC high available environment
• Lead the Database Security Practice subject to Assess, Manage and Architect comprehensive portfolio of database security to ensure data privacy, protect against insider threats, and enable regulatory compliance for both Oracle and non-Oracle Databases and deploy reliable data security solutions that do not require any changes to existing applications in Implementation of Oracle Audit Vault, Database Vault, Data Masking, Database Firewall and Oracle Transparent Data Encryption
• Assisted in database highly privileged account (HPA) management on Cyber Ark to centrally secure, manage and monitor privileged accounts adhering to Audit and compliance standards
• Lead to Build and Manage On-Shore and Off-Shore technical teams to provide operational support for day to day activities and allocate resources to manage large mission critical projects
• Collaborate with business stakeholders, vendors and inter department members to manage the road map to achieve milestones in timely manner.

Confidential

Principal Database Consultant

Responsibilities:

• Evaluate Databases with “highly sensitive”, “sensitive” and “No Sensitive data
• Application users: SQL Injection attacks in Web applications, Insider Threat
• Access Control: Access to production data in non-secure environments and production systems for trouble shooting
• Administrative Account Misuse: System admin, DBA, Application Admins, Stolen credential, Inadequate training, Malicious Insiders
• Operations: Lost/Stolen Backups and Direct OS Access
• Network Security: first line of defense for both Oracle and non-Oracle databases, review monitor database activity on the network to help prevent unauthorized access, SQL injections, privilege or role escalation, and other external and internal attacks - all in real time
• Extensive Experience in Oracle RAC Databases with Multi Nodes configurations
• Implemented Data Guard for DR and Oracle Golden Gate for Data Replication to Data Warehouse Databases
• Lead the Engineered Systems acquisitions, deployments of Exadata V2 Full and Half RACKS
• Expertise on Configuring Multi node RAC Database & troubleshooting the cluster databases & maintaining RAC Instances

Confidential

Database Consultant

Responsibilities:

• Consulting Database Management Directors and Team to implement Oracle Data Vault, TDE Encryption to SAP and Oracle Clinical Databases.
• Lead and manage Off Shore DBA Teams in day to day database activities and to maintain high available business critical database management systems in Oracle and SQL Server
• Oracle Database Wallet Management on Oracle RAC databases at shared location
• Extensively using BR*Tools for SAP database backup and recovery.
• Working as DBA Lead for Oracle Grid Implementation Project on Oracle RAC and Non RAC databases
• Involved in refreshing Oracle Clinical databases from Production to QA and Dev environments
• Supporting and highly involved in Tuning Data Warehouse Oracle database and ETL processes on RAC
• Use Erwin /Toad to Reverse Engineer the other legacy databases required for Data Integration purposes.
• Implementing Oracle ASO, Data Vault, Database Audit and TDE, Wallet Management AES 256 Bit encryption on SAP Databases

Confidential

Database Consultant

Responsibilities:

• Working as Lead DBA/Developer for managing HA/MAA Solution on multiple Clustered and Non Clustered Oracle and SQL databases under Linux and Windows environments
• Primary responsibilities include Install, Maintain and support SQL Server 2005, 2008R2 databases on VM servers and Oracle 10g/11g RAC on Virtualized Servers using Virtual Manger for 2 Nodes on Linux environment and Grid Control on Windows
• Installation and Configuration of Oracle and SQL Server 2005 databases on new Validated Systems/Servers using IQ Scripts
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Implemented Impreva SecureSphere to
• Protect data located in databases and files, in physical or virtual data centers
• View and analyze rights, control access, and monitor data usage for all users, including privileged users
• Protects against SQL injection, Cross-Site Scripting, and CSRF
• Block threats targeted at web applications
• High Privileged user monitoring

Confidential

Database Development DBA Consultant

Responsibilities:

• Working as Sr. Oracle DBA for HA/MAA multi-terabyte 27 QA, 8 Dev and 3 Production Databases for OLTP and Data warehouse databases on Solaris environment.
• Primary responsibilities include Install, Maintain and support Oracle 11G RAC and NON RAC and SQL Server, ASM/Non ASM databases
• Performance Tuning using AWR, ASH, ADDM, Backup and Recovery, RMAN Active Cloning
• UNIX shell scripting for data monitoring and automation.
• Support, development and tuning for pl/sql packages, procedures, functions, materialized views, data partitioning, purging and archiving.
• Extensively used Oracle Golden Gate for Data Replication
• Work with Development Teams to create and maintain Multi-site Data Replication using Shareplex and CDC Change Data Capture, Streams
• Performed shared responsibility with Development teams in supporting Bi Weekly Multi site Releases, Change Control and Job Scheduling
• Monitors current DBMS performance and develops procedures, where necessary, to improve the DBMS environment as required.

Confidential, Bronx, NY

Application Manager/Data Architect

Responsibilities:

• Working as Application Manager and Architect for Oracle, SQL Server and MySQL Databases in 24/7 environment
• Major responsibilities includes maintaining, support and upgrading EMR - Clinical and Financial apps from GE Centricity Reassess and modify business process work flows to be Integrated into Data warehouse
• Responsible for managing team of 8 for database management, development and reporting services.
• Active participation and lead in developing Business Intelligence Data Warehouse for Morris Heights using Oracle OBIEE
• Plan, install, configure and perform upgrades of Oracle 9i,10g,11g and Oracle BI software on ASM/Non ASM, SQL Server 2000/2005
• Maintenance of Oracle, OBIEE, My SQL and SQL Server heterogeneous environment
• Extensively work with Infrastructure Managers to develop optimal hardware and software configurations for both OLTP data ware house databases and Healthcare applications on Citrix servers.
• Create and Maintain Oracle Data guard, Physical Standby database used for Ad Hoc Reporting
• Specializing in instance tuning and SQL optimization using AWR, ASH, ADDM, SQL Advisor and SQL Profiler

Confidential

Sr. Oracle DBA / Developer

Responsibilities:

• Primary Responsible the corporate HAA Solution for OLTP, data warehouse and multiple data marts databases in both Oracle and SQL Server 2000 and 2005 databases on Linux and Windows Platforms.
• Perform a combination of Production and Development DBA as developer responsibility in all phases of Project life cycle\
• Plan, install, configure and perform upgrades of Oracle 9i,10g,11g software adhering to SOX and HIPPA rules.
• Design and manage OLTP and Oracle Data warehouse built using KIMBALL approach having Star Schema Design

Confidential

Sr. Oracle Development DBA

Responsibilities:

• Worked as Sr. Oracle Development Database Administrator and mentoring junior DBA’s and Developer
• Primary Responsible the corporate OLTP (500 G), data warehouse (3.5TB)and data mart (1TB) databases 24x7 Production environment including On Call Off Hours Support
• Plan, install, configure and perform upgrades of Oracle 9i,10g,11g software and Application Servers on AIX and Linux platforms
• Monitoring multiple Oracle databases RAC and NON RAC using OEM and Grid Control
• Installing Oracle RAC, ASM, OCR (CRS and Voting Disk), Grid Control
• Work closely with Corporate Infrastructure Team to Architect LUNS, Disks, Redundant Networks, DR strategies
• Closely working to SOX compliance team to provide them regular SOX Audits reports related to User Security Access/Failures, Backups and Database Change Control modifications
• Design and implement database backup and recovery procedures(RMAN) for cold and hot backups
• Responsible for performing daily maintenance tasks including SQL tuning using explain plan, tkprof, AWR reports
• Involved in Planning and Execution of Data Migration Path and Life Cycle from Hosted IBM environments to In-house Data Marts after few acquisitions

Confidential

Sr. Oracle DBA

Responsibilities:

• Working as Sr. Database engineer and Oracle Database Administrator for Production, QA and Development
• Environment with On Call Support 24x7, Designed and Implemented Development, Staging and Operational Production Databases for B2C internet Application
• Manage and implement regular Oracle, Solaris release/fixes.
• Data Analysis and Data Migration from oracle and legacy databases.
• Fully Involved in ETL Process for Data Extraction, Data Conversion, Data Scrubbing and Data Loading for VLDBs.
• Fully involved in design, development and maintenance of Data warehouse and Operational Data Source (ODS)
• Used data partitioning and read only table spaces methodology for Warehouse DSS systems to reduce backup and data loading schedules
• Created Database Schema Objects such as Tablespace, Data Files, Links, Rollback Segments, Tables, Views and Indexes constraints, synonyms, sequences and Indexes. Used Normalization techniques to maintain database integrity.
• Responsible for creating and managing Oracle Data Guard, backup/recovery strategies