Senior Database Architect Resume
Wallingford, CT
SUMMARY:
- Versatile IT Professional with over 15 years of progressive IT experience as Senior Level Database Administrator in finance, retail warehousing and logistics industries.
- Results oriented with demonstrated experience in the architecture, engineering, implementation and support of cutting edge information technology solutions to address the needs of the business.
- Skilled in communicating effectively at all levels of an organization and presenting complex technical concepts in a concise business ready fashion.
- Analytical thinker, who thrives under pressure and enjoys working with fellow team members and leadership to mature the organizations operational capability.
- Having over 15+ years of experience as SQL server and Oracle DBA and development in IT Industry, which includes a combination of Good database technical knowledge along with Change Management, Production Support and Delivery Management
- 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/Cluster Server Installation, Configuration, Up - gradation, Database Modeling, Database Design (physical/logical), Replication, Application Support, Performance Tuning/ Optimization, User/Security Administration, Backup/Recovery, and Maintenance.
- Experience in upgrading SQL Server 2005 to SQL server 2008 and SQL Server 2008 to SQL Server 2012.
- 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 database design, 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
- Worked with Internal/External Auditors for the BSA, SOX, and PCI compliances and implemented security and change control process
- Developed/Automated and implemented process flow for the Database backups and routine maintenance process including Database Replications.
- 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.
- 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 configuration management and code version control
- Experience in Performance Tuning at Database Level and Query Optimization
- Strong Troubleshooting and Problem Solving skills.
PROFFESSIONAL SKILLS:
DATABASES: Sql Server 2012, 2008, 2005, 2000, 6.5. Oracle 11g, 10g, Informix IDS 11, 10, 9, 7, 6. Sybase 12.5, MySQL 5.6
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, Power Shell
HARDWARE: Unix, Windows
PROFESSIONAL EXPERIENCE:
Confidential, Wallingford, CT
Senior Database Architect
Responsibilities:
- Managed the SQL Server migration project from, 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.
- 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 SSIS packages to synchronize data model across Oracle and 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.
- Imported data from XML files and exported data to XML files.
- Built numerous shell scripts to alert, monitor and report on the database profile and system performance using Power Shell.
- Created SSRS for daily report basis for the assigned users.
- 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 and Oracle Server administration experience.
- 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
- Administered Sybase 12.5 databases.
- Performed POC on MySQL
Confidential
Database Architect
Responsibilities:
- Designed, implemented and maintained multiple databases.
- 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 Oracle 10g to 11g without a single problem.
- Led the team to migrate the databases smoothly when upgrading the UNIX servers.
- Helped UNIX team upgrade the UNIX servers and configure the EMC Clarion systems.
- Upgraded the Informix Engine and tools from IDS 7.2 to IDS 10.0 without a single problem
Confidential
Database Administrator/Lead Developer
Responsibilities:
- Administrated the databases and led the development team to develop applications.
- 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 Confidential system and designed the database to support centralized Confidential 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 Confidential 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. .