SKILLS:

Please use this table to list the skills noted in the Required/Desired section of the Peoplefluent requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Skill experience Last Used:

• Database experience in database design of relational databases and database normalization.
• SQL Server database design and optimization
• Data cleansing/conversion uses scripts in SQL Server.
• ETL/Automation using Integration Services (SSIS)
• SQL Server standards in creation and deployment of new database objects.
• SQL Server Transactional Replication.
• SQL Server security and maintenance of security objects.
• A demonstrable understands of object promotion strategies between databases in different development environments (Dev, Test, QA, and Production).
• Experienced in working with large databases of 300 GB or greater.
• Ability to see problems and solutions from the enterprise perspective.
• The ability to mentor staff not familiar with relational database concepts on the advantages and reasons for database normalization.
• Familiarity with flat file and index table database construction as used in mainframe database applications.

EMPLOYMENT HISTORY:

Confidential, Peoria, IL

SQL Server Production DBA

Responsibilities:

• Upgraded SQL 2005 Server to SQL 2008 Server for processing critical databases.
• Monitored SQL software license usage, requested additional licenses when needed.
• Created and maintained various databases in Production environment using SQL Server 2008R 2/ 2008/2005/2000/7.0
• Planning the location of Data, Index, and Transaction log files on the disk
• Provided support for Transactional Replication/Mirroring
• Installed and configured 2 - node Cluster Configuration (Active/Passive) in SQL Server 2005/2008/2008R2
• Created documentation to Install SQL Server 2005/2008, apply Service Packs, Hot Fixes
• Responsible for MS SQL Server 7.0/2005/2008/2008 R2 configuration and provide 24*7 support to all Production Servers
• Used SSIS, DTS to extract, transform and consolidate data from different sources
• Conducting root cause analysis of application availability and narrow down to issues related to database bottlenecks.
• Resolving locking and blocking issues
• Migrated and tested DTS packages to SQL Server 2008/2005/2000/7.0 to Integration Services (SSIS). Tuned the Production Server to get Performance improvement by using SQL Profiler, SQL Commands and Database Tuning Advisor
• Enhanced Performance by reviewing Disk Configuration and storage allocation
• Documented changes to support change control procedures in the company
• Involved in Performance tuning for Source Databases, Target Databases
• Maintain reliability and availability of existing MS SQL environment.
• Suggesting Cost saving Techniques, Designing/ Implementing Backup policies for Databases.
• Involved in automated daily, weekly and monthly system maintenance tasks such as database. Backup, Replication verification, Database Integrity verification and indexing updates.
• Managed Server Roles, Adding Login’s, User Roles, Groups to MS SQL Server and maintaining proper security procedures.

Environment: MS SQL Server 7.0,2005, 2008, 2008R2 Windows 2003 Server Enterprise, IIS Web Server, XML, Visual studio 2005, .NET, MS Share Point, T-SQL, OLAP/OLTP, TCP/IP, SAN, SSIS, ETL, XSLT, Informatica, Tivoli, Microsoft report analyzer, HP-UX, AIX, Best Practices Analyzer (BPA), System Center Operations Manager 2007 (SCOM), VB script, HTML, CSS, JavaScript, DNS, network IP, Windows 2003, 2008, MS Office, IIS and Oracle, Sybase

Confidential, Cincinnati, OH

SQL Server Production DBA

Responsibilities:

• Upgraded SQL 2005 server to SQL 2008 server for processing critical databases.
• Monitored SQL software license usage, requested additional licenses when needed.
• Create and maintained various databases in Production environment using SQL Server 2005/2008
• Planning the location of data, index, and Transaction log files on the disk.
• Provided support for Transactional Replication.
• Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL Server 2005.
• Created documentation to install SQL Server 2005, apply service packs, hot fixes and clustering installation.
• Responsible for MS SQL Server 2005 configuration and provide 24*7 support to all Production Servers.
• Used SSIS to extract, transform and consolidate data from different sources into Data Warehouse.
• Conducting root cause analysis of application availability and narrow down to issues related to database bottlenecks, or network latency.
• Resolving locking and blocking issues.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Tuned the Production server to get performance improvement by using SQL Profiler, SQL Commands and Database Tuning Advisor.
• Enhanced performance by reviewing disk configuration and storage allocation.
• Documented changes to support change control procedures in the company.
• Involved in Performance tuning for source databases, target databases.
• Maintain reliability and availability of existing MS SQL environment.
• Suggesting Cost saving Techniques, Designing/ Implementing Backup policies for databases.
• Involved in automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Managed Server roles, adding Login’s, User roles, groups to MS SQL Server and maintaining proper security procedures.

Environment: MS SQL Server 2005, 2008, Windows 2003 Server Enterprise, IIS Web Server, XML, Visual studio .NET, MS Share Point, T-SQL, OLAP/OLTP, TCP/IP, SAN, Share point, SSIS, ETL, XSLT, Microsoft report analyzer, HP-UX, AIX, Best Practices Analyzer (BPA), VB script, HTML, CSS, JavaScript, DNS, network, IP, Windows 2003, 2008, MS Office, IIS and Octopus

Confidential, Beaverton, OR

SQL Server Production DBA

Responsibilities:

• Installed, configured, administered and secured SQL Server 2008. Upgraded SQL Server 2005 to 2008.
• Designed and created databases to support the user interfaces.
• Performed Log Shipping on multiple SQL Server databases.
• Provided support for High availability and Disaster Recovery (DR) of for critical database systems.
• Provided support for complex Transactional Replication environments.
• Performed Database Backups to ensure minimum loss of data during disasters and restored from
• Backup when the need arise.
• Set up security and roles, DTS packages and maintenance plans, Jobs, Alerts and Operators in SQL Server.

Environment: SQL Server 2005 & 2008, Windows 2000/2003 Server, VB script, IBM WebSphere, Crystal report, MS Office, ETL, Service Oriented Architecture, T-SQL, OLAP, Performance Point, .NET, DB2, DDL, DML, OSSQL, ETL, TCP/IP,SAN,DTS, SSIS, Team Foundation Server, J2EE, VB script, ProClarity, Powershell, Microsoft report analyzer, windows 2000, 2003, HTML, CSS, JavaScript, IIS,XML, DNS.

Confidential, Chicago, IL

SQL Server Production DBA

Responsibilities:

• Active participation with customers in understanding their business process and suggesting optimal database structure, practices and tools on specific projects, ensuring high customer satisfaction rates.
• Setting up processes for regular backups and restore methods, and ensuring the processes are followed.
• High emphasis on database security, permissions, user management and following best industry practices.
• Setting up monitoring through batch scripts
• Installing, upgrading and applying the latest service packs/hot fixes.
• Provided High availability through Clustering, Mirroring, Replication (Transactional)
• Production database administration of highly critical databases.
• Migration/Moving database servers between different platforms/locations and setting up test, QA and production database environments.
• Installation of SQL Server 2005. Upgrading SQL Server 2000 to SQL Server 2005 using side-by-side methods
• Planning for the DR

Environment: SQL Server 2000/2005 Enterprise Edition, Performance Point, Crystal Report, SAN, ProClarity, Java script, HTML, Enterprise Manager, ERStudio, UML, ETL, MS Project, DDL, DML, OSSQL, MS Office, VBScript, MS Access 2000 & Windows 2K, 2005 platform, Java, IIS XML, J2EE, HP-UX, AIX, Perl, UNIX Shell Source Control Tools, IBM WebSphere, HTML, CSS, JavaScript , Team Foundation Server , Service Oriented Architecture

Confidential, Albuquerque, NM

SQL Server DBA

Responsibilities:

• Technologies involved in this application include SQL Server 2000, 2005 Replication , Microsoft Analysis Services and Microsoft DTS (ETL).
• Created DTS packages for the data cleansing/transfer ( ETL ) and transformation.
• Designed Database Schema using third party tools like Erwin (ER Studio).
• Created job schedules to automate the routine tasks.
• Performed Database Normalization.
• Coding of several database Triggers, Stored Procedures and maintaining Integrity constraints.
• Generated report using Microsoft report analyzer.
• Implemented PMI Project Lifecycle Methodology processes.
• Migrated databases from SQL server 2000 to SQL server 2005.
• Migrated old dts packages into SSIS packages.
• Determine the problems such as dead lock, blocking and fix the problem.
• Partitioned tables, Views to run query faster.
• Supported 24*7 production support and solved all kinds of critical problems.
• Created reports by using bar chart to analyze critical data in SSRS 2005.

Environment: T-SQL, SQLServer2000, 2005 OLAP, Performance Point, .NET,DB2, MS Office ,DDL, DML, OSSQL, ETL, TCP/IP,SAN,DTS, SSIS, Team Foundation Server, J2EE, VB script , ProClarity, Powershell , HP-UX, AIX, Microsoft report analyzer, windows 2000, 2003, HTML, CSS, JavaScript ,IIS,XML, DNS, Perl, UNIX Shell , Unix, ORM, Service Oriented Architecture ,Source Control Tools ,ERStudio 7.x.

Confidential, PA

Database Administrator

Responsibilities:

• Installing, upgrading and applying the latest service packs/hot fixes.
• Performed Database Backups to ensure minimum loss of data during disasters and restored from back-up when the need arise.
• Provided support for Transactional Replication environments.
• Supported 24*7 production support
• Performed Database Normalization.
• Setting up processes for regular backups and restore methods, and ensuring the processes are followed.

Environment: Windows NT, Windows 2000/2003 server, ETL, MS SQL Server 2000, Java, VBScript, MS Access, IBM Websphere, Service Oriented Architecture