Senior Database Architect Resume Wallingford, CT - Hire IT People

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
Migrating existing production oracle 10gR2 to 11gR2 and upgrade Oracle Databases from 9i to 10g
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 Oracle Forms 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, MS Visio, idera, Reflections, Putty

SCRIPT LANGUAGES: AWK, SED, C Shell, Korn shell

HARDWARE: Unix, Windows

S: ITIL V3, Six Sigma Yellow Belt

PROFESSIONAL EXPERIENCE:

Confidential, Wallingford, CT

Senior Database Architect

Responsibilities:

Managed the ORACLE migration project from 10g to ORACLE 11g, producing an overall delivery of this project that brought savings of $50K to the organization. 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.
Configured Data Guard for Disaster Recovery using snapshot and standby mode on 11gRAC Database
Installed intelligent agent 11g for grid control and created response file for RAC Database
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.
Migrated 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.
Upgraded Informix IDS 10 to Informix IDS 11 and Informix tools I4GL, ISQL, and ESQL/C

We provide IT Staff Augmentation Services!

Senior Database Architect Resume

Wallingford, CT

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship