SUMMARY:

• Efficient and collaborative IT Management professional with strong analytical and cross organizational skills, with in IT application development, data architectural design for RDBMS and data warehouse applications, and administration, includes 17 years of expertise in Information Technology Systems. Can bring strong leadership and technical skills to your environment, seeks progressive opportunities to lead in planning, monitoring, and driving the on - schedule and within budget delivery of complex technology, business, and process improvement solutions apart from challenging business intelligence and High Availability environments, high Data security, Data Migration & Data Management projects.
• An IT Management professional with 17 years of technical and management experience in government
• Oversaw the complete migration of legacy database systems into Oracle RDBMS involving application / database architecture design, database modeling, logical and physical database design, and migration in three tier architecture for Department of Health and Human Services ( Confidential ), Montgomery County, MD.
• Administration of Oracle Multitenant Databases and PDBs on Oracle 12c, RAC on 11gR2, 11gR2 Active Data Guard, 11gR2 Advanced streams Replication
• Transparent Data Encryption ( TDE ) for tablespaces in PDBs for data at rest with Keystores.
• TCPS ( Secure TCP/IP with SL and TSL ) using Oracle Wallet for server and client certificates, exchange certificates, export, import of wallets, Server and Client network configuration to use certificates for data in transit.
• Planning and performing Data Center migration
• Oracle Database server 11gR2 migration into Oracle 12C in Solaris and Linux servers including data migration
• Oracle 10gR2 migration into Oracle 11gR2 with two node RAC and Oracle Streams Replication
• Data Migration expertise from various data sources into Oracle Data Warehouse using ETL tools as well as regular PL/SQL programming. Well versed with Data Loading operations and performance tuning.
• Experience in Software Development, COTS Product implementation, Operation & Maintenance, Information Security, Business Continuity Planning, Auditing, Networking and IT Service Management.
• Over 17 years of experience in various aspects of project management.
• Possess Quality Assurance, Quality Control, Information System Auditing, HIPAA Compliance, Change Management, Information Security Management and Risk Management knowledge and experience.
• Strong interpersonal and teamwork skills. Excellent oral and written communications skills
• Excellent Problem Solving Techniques and Analytical Skills. Trained in Root Cause Analysis by International Atomic Energy Agency ( IAEA ) Team.
• Skilled in building, training, and mentoring high-performing teams.
• Verify correctness and completeness of data model, data relationships, mappings, and definition.
• IT hardware and software Assessment Management ( ITAM ) .
• Develop design documentation, Installation Guides and Release Notes for all development efforts.
• Provide database programming support and troubleshooting.
• Determining security policies, ensuring data security by implementing database auditing and monitoring user access for HIPAA compliance.
• Database design, Data Management expertise, Data migration expertise from various sources Database Administration ( 11gR2/12c on RAC- OLTP and DataWarehouse )
• Database Administrator with 22 years of experience in installation and administration of Oracle databases (8i/9i/10g/11gR2/12C), backup and recovery, performance tuning, performance monitoring, schema maintenance in platforms include Sun Solaris, LINUX and Windows servers.
• Administration of Oracle Multitenant Databases and PDBs on Oracle 12c, RAC on 11gR2, 11gR2 Active Data Guard, 11gR2 Advanced streams Replication
• Planning and performing Data Center migration
• Oracle Database server 11gR2 migration into Oracle 12C in Solaris and Linux servers including data migration
• Oracle 10gR2 migration into Oracle 11gR2 with two node RAC and Oracle Streams Replication
• Transparent Data Encryption ( TDE ) for tablespaces in PDBs for data at rest with Keystores.
• TCPS ( Secure TCP/IP with SL and TSL ) using Oracle Wallet for server and client certificates, exchange certificates, export, import of wallets, Server and Client network configuration to use certificates for data in transit.
• Data Migration expertise from various data sources into Oracle Data Warehouse using ETL tools as well as regular PL/SQL programming. Well versed with Data Loading operations and performance tuning.
• Expertise in logical backups, Hot/Cold Backup, RMAN Backups, Recovery and Cloning of databases.
• Implemented RMAN for backups and Point-In-Time Recovery strategy.
• Experience in Configuring RMAN with Catalog for Differential, compressed Backup and Recovery.
• Expertise in data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Experienced in features like Log Miner and Flashback Data Archive, Schema Management, Data guard and RMAN in Oracle 11gR2.
• Implemented Database cloning to disaster recovery database using physical standby database.
• Successfully installed, configured and supported Streams Replication.
• Experience in configuring Data guard 11g R2 for physical standby databases.
• Successfully configured and implemented Physical Standby Database using Oracle DATAGUARD feature for High availability configuration and reporting.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan.
• Extensive experience on Partitioning
• Extensively used Oracle Enterprise Manager-Database Control, 10G Grid Control for monitoring and tuning the databases.
• Cross Platform Upgrades/Migration of Databases from Oracle 8i to 9i, 9i to 10g and 10g to 11g and 11gR2 to 12C.
• Extensively used SQL*Loader and External Tables to load data from flat file to oracle server.
• Used SQL Access Advisor, SQL Tuning advisor, Segment Advisor.
• Extensively used Advance Replication (Oracle Streams) of oracle databases for high availability.
• Converted single instance databases to multi node RAC environment for high availability and load balancing.
• Extensively worked on Oracle10g/11g Real Application Clusters (RAC) environment on different nodes.
• Specialized in tuning on RAC databases and monitoring for high availability.
• Expert in writing Unix shell scripts and assigning cron jobs for day to day activities.
• Extensive experience in writing SQL, PL/SQL packages, functions, stored procedures, triggers
• Responsible for working on database design and data requirement analysis using ERWIN data modeler and Toad for Data Analysts. Worked in database design, logical and physical modeling of the database using CASE tools like ERWIN, and normalization/de-normalization of database tables and object sizing.
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
• Load data from OLTP systems into data warehouse databases.
• Strong knowledge and experience of managing Oracle 9i,10g RAC and 11g RAC environments using the OEM Grid Control tools.
• Extensively used Oracle support and Metal ink to troubleshoot the problems and issues. Data Architecture / Database Design ( OLTP and DataWarehouse )
• Design and build complex relational databases with 3rd NF and data warehouses with STAR and Snow Flake design as well as hybrid models.
• Translating Logical design into one or more databases.
• Data Flow determination through successive stages
• Building Data Marts using materialized views with various refresh policies.
• Developed ETL tool using PL/SQL. Well versed with Informatica and AbInitio ETL tools.
• Monitor performance of database management systems in VLDB environments.
• Provide performance tuning of database systems for query and data loading performance, including various data partitioning schemes, indexing, data model review/updates, etc.
• Manage multiple projects simultaneously with focus on project planning, monitoring, budgeting, resource negotiation, scope containment, change management, conflict resolution, risk mitigation, implementation, project status reporting, documentation and other PMO related processes.
• In-depth skills in all phases of the software development life cycle (SDLC), including planning, estimating, budgeting, Work Breakdown Structures, scheduling, execution, control, risk, change control, configuration management and quality management, testing, delivery and maintenance and enhancements using Agile methodology while ensuring compliance with PMO guidelines.

AREAS OF E XPERTISE:

• Oracle RAC
• Data Models-Conceptual/Logical/Physical
• Business Analysis
• Data Security / Auditing
• High Availability Solutions
• Communications mgmt
• Performance Tuning
• High Performance Solutions
• Quality Assurance
• Data Warehouse
• Highly Secure Data Access
• Change Management
• Data Migration
• Data Migration Strategies & Tools
• Risk Analysis / Mitigation
• High Availability
• Data Integration
• Operations Management
• Oracle Streams Replication
• Database Design - Logical/Physical
• Schedule Management
• Oracle Data Guard
• Data Warehousing
• Cost Management
• Logical / Physical Design
• Data Analysis
• Data Dictionary
• Information Security

TECHNICAL SKILLS:

Development Platforms: JAVA, .Net, .Net CORE, C#, Python, Ruby On Rails

Operating System: Solaris UNIX 9.0, 2.5.1, RedHat Linux (RHEL 5.0 & 4.0 ), Windows Server 2003

Languages: UNIX Shell Scripts, T-SQL, SQL, PL/SQL, C, C++, windows scripts.

Hardware Platforms: PC x86, Sun SPARC T4/T5, Dell Power Edge, HP

Web Server: Oracle iAS, Apache. JBOSS

RDBMS: Oracle 12c, 11gR2, 10g, 9i, 8i, 8.x & Oracle 7.3, Sql Server 12, SQL Base 6.x and 7.x

RAC / HA Solutions: 11gR2 RAC, Oracle Advanced Replication with Streams, ASM, SAN and Data Guard, Oracle 12c Grid Control

Data Warehouse: Oracle Warehouse Builder (OWB) 10g, Oracle BIEE 10g

Tools: / Utilities SQLServer SMCC, Oracle Data Guard, RMAN, ASM, Grid Control, AWR, ADDM, ASMM, AMM, PL/SQL Developer, Data Pump, Export/Import, SQL Loader, Designer 2000, TOAD, JDeveloper, Procedure Builder, SQL*Net, ErWin, ER/STUDIO, DBArtisan, Rational Rose Clear Case, Clear Quest, BMC Remedy, AUTOSYS, CVS, Crystal Reports X, XI, Ab Initio, Informatica

Others: IBM JAZZ, JIRA, SharePoint

PROFESSIONAL EXPERIENCE:

Applications Manager

Confidential, DC

Responsibilities:

• Managed in house application development effort for modernizing Office of Workers’ Compensation, a $4 million application. An efficient team of about 12 resources including Project Manager, DBAs, Business Analysts, .Net Developers, Web Developers, Testers ec…
• Managed the DBA team and assisted them in migration from Oracle 11gR2 to Oracle 12c Multitenant database.
• Designed Data architecture taking into account the modernization effort with High Availability solution with 2 node RAC, Advanced Stream Replication and Oracle Active Data Guard.
• Refined the existing project management and business processes making them more efficient.
• Established proper communication management
• Established systematic Change Management process.
• Developed the project conforming to SDLC and PMI Project management processes using hybrid model of Agile/Scrum and waterfall methods.
• Built very efficient and self-motivated team with team building effort and brought a sense of belongingness among the resources.
• Arranged necessary training to the resources to enhance their skills to aid the project.

DBA Team Lead

Confidential, Silver Spring, MD

Responsibilities:

• Administration of Oracle Multitenant Databases and PDBs on Oracle 12c, RAC on 11gR2, 11gR2 Active Data Guard, 11gR2 Advanced streams Replication
• Planning and performing Data Center migration
• Oracle Database server 11gR2 migration into Oracle 12C in Solaris and Linux servers including data migration
• Oracle 10gR2 migration into Oracle 11gR2 with two node RAC and Oracle Streams Replication
• Designing and configuration Oracle 11gR2 Grid Control and Real Application Control system with 2 Node RAC with a Failover site using Oracle Streams for replication.
• Configuration of Bi-Directional, 2 way Advanced Replication using Oracle Streams. Identifying and resolving streams replication issues.
• Configuration of Transparent Data Encryption ( TDE ) for PDBs with Keystores
• Configuration of TCPS ( Secure TCP/IP with SL and TSL ) using Oracle Wallet for server and client certificates, exchange certificates, export, import of wallets, Server and Client network configuration to use certificates
• Setting up Physical Standby database using Oracle Data Guard for Disaster Recovery. Performing manual failovers for maintenance. Syncing up standby manually.
• Designing Backup and recovery plan using Oracle RMAN. Creation of scripts for Full as well as incremental backups. Configuration of Block Change Tracking feature for faster incremental backups.
• Performed performance tuning for the applications and assisted developers in tuning their SQL queries before deployment to production. Used SQL Plan Management and AWR reports extensively to identify performance issues, identifying poorly performing SQLs and tuning them based on their execution plans, providing hints, Forcing optimizer to use specific execution plan for a particular SQL all the time.
• Excellent in PL/SQL programming. Wrote PL/SQL scripts for creating stored procedures, triggers for auditing and for data Transformation phase of ETL process to load data in data warehouse as well during data migration process from legacy systems.
• Skilled in writing Unix shell scripts. Used the shell scripts for setting cron jobs, RMAN backup/recovery, Alert log monitoring and various other monitoring scripts.
• Various Oracle tools like SQL Loader, Data pump Export/Import used for data migration and data movement needs.

Senior Consultant

Confidential, Reston, VA

Responsibilities:

• Database architecture and application design for data warehouse and data mart project for ULDD project.
• Data modeling ( STAR schema, Snow flake schema design ) for data warehouse and data marts.
• Creation of Datawarehouse related objects like Materialized views, Partitions (Range, Hash, Compound), Bitmap Indexes, External Tables, used External tables, CTAS for efficient loading using Direct path loading and parallel DML ( Append Hint for Insert statement ), Partition Exchange
• Responsible for production support as well as Release support of Confidential ’s Single Family Technology eBusiness Data warehouse System environment ( Desktop Underwriting ) consisting of 18TB size production database having Delivered Loans, Underwriting information etc.
• Administration and performance tuning of database with 4 node 11gR2 RAC & Grid Infrastructure
• PL/SQL code development, performance tuning of existing code.
• Provided support for various application release activities including code migration to various environments using CVS, Code Mover.
• Complete knowledge of BMC remedy tool to manage various Incident tickets and Change tickets like regular, Fast Track, After the Fact, DBMODs etc.
• Providing various reports related to performance, availability, for Credit score analysis.
• Member of disaster recovery planning committee for these applications.

Consultant Project Manager / Lead Data Architect

Confidential, Montgomery County, MD

Responsibilities:

• Implementing PM best practices for the project and perform project activities consistent with the knowledge areas and established PMO and implemented Project Management process.
• Established Software Development Life Cycle (SDLC) and Configuration and Change Management Process.
• Led the team to create the as-is and future system’s requirement of business and functional requirement, requirement traceability document, test cases and scenarios for various component of the AIFCR Application.
• Managed a team in efforts to perform fit gap analysis for various applications.
• Worked with the team to create SDLC documents and review other project artifacts e.g application documentation, requirements document, Interface design documents and etc
• Obtained user participation in requirements gathering and user acceptance testing
• Worked and coordinated with various engineering department across Confidential on performing daily maintenance tasks and other Upgrade project related tasks.
• Conducted weekly status review meeting and provided status reporting, notes for meetings, requirements documents, and project plans
• Identified and documented the project risks and the solution to mitigate the risks working with the team members and stakeholders
• Responsible for planning, staffing, scheduling, budget management, quality control, and coordination of subcontractors and internal technical support staff to ensure plans & resources are coordinated

Consultant - Applications DBA

Confidential, SF, CA

Responsibilities:

• Installation of Oracle 8i Oracle and Applications 11i.on Windows NT Design of database architecture.
• Maintenance of Applications using Application DBA (AD) utilities and Sys. Admin. tools.

Consultant - Oracle DBA

Confidential, Stamford, Connecticut

Responsibilities:

• Application development using PL/SQL. Created stored procedures / Packages and developed test scripts for testing.
• Preparation of ER diagram by reverse engineering using Designer 6i..