SUMMARY

• Having over 15+ years of experience as ORACLE and SQL server DBA and development in IT Industry, which includes a combination of Good database technical knowledge along with Change Management, Production Support and Delivery Management
• Database Management - Backup & Recovery, Performance Tuning, Configuration Database, Tablespace administration, cloning, and managing data dictionary objects
• Implementing new Oracle RAC environments from scratch
• Well versed in advanced Oracle features such as Indexing, Collections, Dynamic SQL and Oracle bulk
• Troubleshoot Oracle RAC Production problems and working effectively with other team members
• Experience in Installing and Configuring SQL Server 2000, 2005, 2008, and 2008R2,2012 and SQL server 2014 on Standalone and Microsoft Clustered servers and in applying latest Service Packs and Hot fixes.
• Guru in MS SQL Server Installation, Configuration, Up-gradation, Database Modeling, Database Design (physical/logical), Replication, Application Support, Performance Tuning/ Optimization, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance
• Experience in upgrading SQL Server 2005 to SQL server 2008 and SQL Server 2008 to SQL Server 2012
• Worked with Internal/External Auditors for the BSA, SOX, and PCI compliances and implemented security and change control process
• Experience in database design SQL Navigator, PL/SQL functions, stored procedures, packages, cursors and triggers and Strong Data Modeling experience
• Develops and captures database performance metrics and apply Oracle database releases and patches
• Experience in configuration management and code version control
• Expert knowledge of RMAN backups, UNIX shells - Korn shell, Perl
• Disaster Recovery: Backup/Recovery, Standby database, Data Guard and Server administration experience.
• Developed/Automated and implemented process flow for the Database backups and routine maintenance process including Database Replications
• Good at Implementing T-SQL Coding Standards and writing policies and procedures for data management
• Experience in developing Stored Procedures, Functions, DDL, DML using T-SQL and PL /SQL
• Experience in Performance Tuning at Database Level and Query Optimization
• Strong Troubleshooting and Problem Solving skills
• Upgraded the Informix Engine and tools from IDS 7.2 to IDS 9.0 and IDS 9.0 to 10.0
• Strong Troubleshooting and Problem Solving skills
• Involved in Disaster Recovery exercise in Remote locations. Which involves/prepare the documents to recover the server in the given time line. Also involved in this exercise to recover the Database Applications servers using given Documents.

TECHNICAL SKILLS

• DATABASES: Oracle 11g, 10g. SQL Server 2012, 2008, 2005, 2000, 6.5. Informix IDS 11, 10, 9, 7, 6. Sybase 12.5
• LANGUAGES: PL/SQL, T - SQL, I4GL, ESQL/C, ISQL, C.
• TOOLS: TOAD, Erwin, Ignite, Oracle Resource Manager, MS Visio, idera, Reflections, Putty
• SCRIPT LANGUAGES: AWK, SED, C Shell, Korn shell
• HARDWARE: Unix, Windows

PROFESSIONAL EXPERIENCE

Confidential, Wallingford, CT

Senior Database Architect

Responsibilities:

• Managed the ORACLE migration project from 10g to 11g, on HP-UX producing an overall delivery of this project that brought savings of $50K to the organization. Used Golden Gate to migrate Oracle 10g to 11g on HP Servers. Coordinated the complete lifecycle of the project that included over 20 senior resources spread across development, quality assurance, business and operations.
• Tuned and coordinated databases to handle high volume growth and application queries to run faster.
• Designed and implemented the database archival strategies for databases without slowing down the system performance and ensuring system ability to recover from any given point of time.
• Played a key role in successful migration of CheckfreePayLink payment processing system across data centers.
• Designed processes and scripts to synchronize data model across Oracle and CFPLink SQL databases.
• Architected transactional flow across distributed databases spanning multiple data centers resulting in the maintenance of the integrity and consistency of data across distributed databases.
• Implemented new Oracle RAC environments from scratch.
• Well versed in advanced Oracle features such as Indexing, Collections, Dynamic SQL and Oracle bulk.
• Troubleshoot Oracle RAC Production problems and working effectively with other team members
• Disaster Recovery, Backup/Recovery, Data Guard, Partitioning and Oracle Server administration experience.
• Upgraded SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL server 2012..
• Built numerous shell scripts to alert, monitor and report on the database profile and system performance.
• Oversaw replication between production and disaster recovery sites to ensure business continuity.
• Built numerous shell scripts to alert, monitor and report on the database profile and system performance.
• Upgraded Informix IDS 10 to Informix IDS 11 and Informix tools I4GL, ISQL, and ESQL/C
• Administered Sybase 12.5 databases.
• Involved in migrating Sybase 12.5 databases to SQL Server 2005.
• Performed POC on MySQL

Confidential

Database Architect

Responsibilities:

• Performed capacity planning for projected transactional growth to assess current capabilities and evaluate potential changes needed to accommodate growth.
• Implemented the data replication for business continuity between the primary site and disaster recovery site.
• Installed and maintained SQL server for Schedule Reporting Processor (SRP) engine to reduce the load peak times on Informix databases.
• Created stored procedures to extract the data during off peak time from the Oracle databases.
• Developed Shell scripts to move data from frontend environment to history servers on daily basis.
• Limited the user’s access according to PCI, SSAE 16, and Bank Secrecy Act.
• Designed and implemented migration plan for a corporate move across two cities to migrate databases within a two minute production outage SLA.

Confidential

Database Supervisor

Responsibilities:

• Managed the systems migration project by allocating the resources effectively and efficiently in a scheduled manner without any production problems.
• Upgraded the SQL Server from 6.5 to 2000 without a single problem.
• Led the team to migrate the databases smoothly when upgrading the Window servers.
• Helped UNIX team upgrade the UNIX servers and configure the EMC Clarion systems.

Confidential

Database Administrator/Lead Developer

Responsibilities:

• Implemented High Availability Data Replication between production and disaster recovery systems
• Upgraded the Informix Engine and tools from IDS 7.2 to IDS 9.1 without a single problem.
• Led the team to migrate the databases smoothly when upgrading the UNIX servers and implementing the SAN EMC Clarion system.
• Led the team to develop the centralized ACH system and designed the database to support centralized ACH system.
• Supported 24 X 7 all production, DR site, and lower environment database servers.
• Critical team member involved in moving the DR site seamlessly from Shelton to New Haven.

Confidential

Lead Developer

Responsibilities:

• Led the team in designing and coding GEN7 platform (walk-in real time bill payment system) and participated in database and tables design. Added audit trail for the main tables.
• Led the team to design, code, enhance and support the various client implementations and internal applications.

Confidential

Sr. Developer

Responsibilities:

• Designed, developed and supported the client report applications including payments, adjustments, and NSF data for major clients such as AT&T and Ameritech
• Designed and created ACH and reconcile applications for banking department.
• Helped peer developers to design and code the applications.

Confidential

Software Developer

Responsibilities:

• Designed, developed and supported the Agent Screen, Banking Screen, and bad checks applications for internal departments.
• Redesigned and developed more than 40 client applications to migrate seamlessly from old environment to new environment. .