Summary

Accomplished IT professional with extensive background in database architecture, administration, and design and directing data operations. Expertise includes Microsoft database technologies, Microsoft BI tools, CRM technologies, project management, all aspects of software development life cycle and cross-departmental coordination. Recognized for excellent problem solving and leadership skills.

Areas of Expertise:

• Database Administration
• Database Development
• Data Modeling
• Database Maintenance
• Data Warehousing
• Business Intelligence Tools
• Disaster Recovery
• Database Security
• Performance Tuning
• Problem Resolution
• Project Management
• Sarbanes-Oxley Controls
• Over 18 years of experience in the following areas of Enterprise SQL Servers in high volume and high availability (24/7) data centers – SQL Server database installation, administration, maintenance, migration, support, and server management.
• Proficient in RDBMS database architecture, modeling, design, and development with SQL Server databases.
• Extensive knowledge in different version of SQL Server including 2008, 2005, 2000.
• Adept in planning and implementing disaster recovery and providing high availability scalable solutions.
• Expert level experience in the following areas of SQL server technologies:
• ETL processes using SSIS and DTS for data migration 
• Backup and recovery planning, design and implementation 
• Query optimization and performance tuning 
• Administering servers using policy-based management (PBM) 
• SQL Server Analysis Services ( SSAS) in SQL 2008 
• SQL Compliance Manager to audit the production activities
• Deep understanding of software development life cycle (SDLC) and project methodologies.
• Self-motivated, dynamic and an excellent team player with outstanding analytical and communication skills.
• Extensive domain knowledge in Insurance/Financial industry applications.

Technical Expertise

CRM Technologies

Siebel 6.x – 7.x, Siebel EIM , MS Dynamics 4.0

Languages

VB.NET, TSQL, C, VB Script

Databases

Microsoft SQL Server 6.x , 7.0 , 2000, 2005 , 2008 , 2012

SQL Server BI/ETL

SSIS (SQL Server Integration Services) , SSAS (SQL Server Analysis Services) , SSRS(SQL Server Reporting Services) , DTS(Data Transformation Services)

Tools

Visual Studio 2008 DB Team Edition, SQL Server Management studio, Install shield 12.0, StarTeam, SQLLite Speed, SQLCompare, HEAT, ER Studio Ervin 4.2 , SQL Compliance Manager .

Professional Experience

Confidential, September 1997 – Present
Winston-Salem, NC 
Senior Database Administrator

Lead Database Architect – CRM Systems

• Led the database team in the architecture, design, implementation of SQL Server 2008 environment to facilitate conversion of CRM application from Siebel 7.7 to Microsoft Dynamics 4.0.
• Developed the process to extract, transform, and load data from Siebel to Dynamics using SSIS.
• Designed multiple interfaces using SSIS to integrate data between Dynamics and other external applications.
• Developed Stored Procedures, Functions (UDF), Views & Triggers to enforce the business rules.
• Involved in database optimization and performance tuning for CRM environment.
• Created the backup strategy and disaster recovery procedures for CRM application.

Database Developer / Architect – .Net applications

• Designed and developed clustered SQL Server environments for mission critical high availability.Net applications, to support loan origination, pricing, policy servicing, customer maintenance, and Electronic Data Interface.
• Developed conceptual, logical and physical data models of OLTP databases using ER Studio Data Architect.
• Planned and designed infrastructure including storage capacity, RAID configuration and clustering.
• Performed replication across multiple environments to make data and objects available for consumption by other applications and for real time reporting.
• Designed and implemented ETL loads using SQL Server 2008/2005 Integration services and SQL Server 2000 Data Transformation Services to migrate OLTP data to DSS.
• Created tables, views, indexes, stored procedures, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Involved in upgrade of databases from SQL Server 2000 to 2005.

Database Developer / Architect – Siebel Sales Force Automation application

• Architected data integration between Siebel and multiple legacy systems using Siebel Enterprise Integration Manager.
• Configured and optimized configuration to run Siebel Enterprise Integration Manager for data load.
• Prepared complex SQL queries for data extraction, data cleansing, transformation and load from external systems to Siebel.
• Modified and designed batch jobs to import / export data between Siebel database and legacy systems.
• Implemented best practices to create extension tables using Siebel Tools for custom business entities.
• Performed export (exprep) and import (imprep) during deployments to migrate Siebel repositories from one environment to another.

Data Warehouse / ETL

• Designed and implemented ETL loads using SQL Server 2008/2005 Integration services and SQL Server 2000 Data Transformation Services to migrate OLTP data to Operation Data Store.
• Worked collaboratively with Data Warehouse team to contribute in architectural and production support functions.
• Architected ETL processes for time-sensitive loads.
• Participated in SDLC of Enterprise Data Warehouse and Data Marts projects.

DBA– Database process improvements and enhancements

• Designed and developed a process using Visual Studio Team System 2008 (Database edition) and InstallShield 12.0 for automation of database deployments. The process allows for deployment of database changes to non-development environments without the intervention of DBAs, to comply with Internal Audit (Sarbanes-Oxley) requirements.
• Designed and architected a data scrambling process to scramble sensitive data on restore of production data to other non production environments. This process is routinely used by all members of the database team while refreshing production data for test purposes to other databases.
• Developed a solution that monitors scheduled production jobs on all database servers and alerts the on-call DBA by sending an email of any failures.
• Developed a process to periodically store all required database server properties in a central repository to accomplish Disaster Recovery successfully.

Other responsibilities:

• Install, configure and maintain SQL Servers in various environments including development, systems integration, quality assurance, user acceptance testing, customer test and production environments.
• Insure 24 x 7 support of production database environments by being on-call, monitoring alerts, scheduled jobs and other SQL Server processes.
• Perform annual disaster recovery exercises at an offsite location for all production servers.
• Define T-SQL coding standards and database naming conventions and guidelines to be followed by the database development team.
• Performance tuning of long running queries and stored procedures.
• Schedule and monitor re-indexing of tables on a weekly basis to insure optimal performance.
• Evaluate and recommend 3rd party database tools for use by database team.
• Testing of database backup procedures and disaster recovery scenarios on a regular basis.
• Perform software upgrades and install service packs, patches and hotfixes for SQL server during maintenance weekend as recommended by vendor.
• Perform routine database backups using SQLLite, database restores and refreshes, comparisons of database objects using SQL Compare as necessary.
• Support in researching, troubleshooting and resolving production issues.
• Perform code reviews to enforce established coding standards.
• Record all changes to production databases to an activity log as mandated by Internal Audit.

Education

• Bachelors of Engineering in Computer Science, Confidential University