We provide IT Staff Augmentation Services!

Lead Dba/developer Resume

EXECUTIVE 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 Susyems; 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
  • Manage and Lead Confidential /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 T58, 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, 20 Enterprise and standard.

Data Modeling Tools: Erwin, Power Designer

Conceptual knowledge: NOSQL Databases. Autosys for Job Scheduling and monitoring

Technologies: 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

WORK EXPERIENCE:

Confidential

Lead DBA/Developer

Responsibilities:

  • 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.

Confidential, New York, NY

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
  • 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.
  • Configuring RMAN backups to Data Domain using DD Boost
  • Record and Document certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
  • Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
  • 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, New York, NY

Manager Lead DBA

Responsibilities:

  • 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
  • Used Oracle Golden Gate for Data 11g Replication and Data Integration in downstream environments.
  • 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, Edison, NJ

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, Rockaway NJ

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, Parsippany, NJ

Database Consultant

Responsibilities:

  • Working as Lead DBA/Developer for managing Confidential /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, Wireless Warren, NJ

Database Development DBA Consultant

Responsibilities:

  • Working as Sr. Oracle DBA for Confidential /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, Partnership, NY

Sr. Oracle DBA / Developer

Responsibilities:

  • Primary Responsible the corporate Confidential 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

Hire Now