SUMMARY:

• Senior MSSQL DBA with 12 years experience in development and database administration with SQL Server .
• Experienced with SSIS, SSAS and SSRS and Data Warehousing.
• MCDBA, MCTS - Sql Server, and MCSE s.
• Administrator/Developer for MS Dynamics ERP system
• MCSE with experience on Windows Server NT/2000/2003 with Active Directory, Exchange Server.
• Strong written and verbal communication skills, excellent work ethic with a team-player mentality.

TECHNICAL SKILLS:

• 12 years experience in Production database support, proficient in SQL Development and troubleshooting.
• Strong experience in ETL with DTS & SSIS packages, including strong VB script tasks.
• Strong experience with developing SSRS Reporting Services packages, as well as experience with Crystal Reports.
• Experience with SSAS, Data warehouses.
• SQL development includes Sql queries, stored procedures, functions and triggers using T-Sql, xml queries.
• Database administration experience includes design and maintenance of databases, tables, indexes and jobs, installation, configuration, monitoring, space management, security, database backup and recovery, high availability, performance tuning, troubleshooting, and Disaster Recovery within a PCI-compliant clustered enterprise environment.
• Experienced with VLDB's within Active/Passive and Active/Active clustered environment using Transactional Replication, Mirroring, Log Shipping and Change Data Capture techniques.
• solving, analytical and innovation skills.
• Experienced in administration and customization of Microsoft Dynamics ERP platform.

WORK EXPERIENCE:

Confidential, Fort Worth, TX

Contract SQL DBA/Developer

Responsibilities:

• Troubleshoot and correct any SQL-based application issues related to the business flow in support of finacial applications for their client.
• Responsible for deployment of stored procedures and troubleshooting job failures on multiple Sql Server instances.
• Designed and created SSIS packages as well as redesign of existing SSIS packages to ensure ETL data transformations as needed.
• Performed performance tuning and optimization of Stored Procedures, as well as optimization of long-running queries for reports.
• Worked on correction of replication failures between the SQL servers.
• Worked with mentoring other SQL developers during implementation of technical projects.

Confidential, Fort Worth, TX

Sr. SQL DBA/System Analyst

Responsibilities:

• Troubleshoot and correct any SQL-based application issues related to the business flow, to include Purchasing, Receiving,
• Responsible for installing and configuring the Sql Server instances, databases, tables, stored procedures, views, jobs and security.
• Performed performance tuning and optimization of Stored Procedures, as well as queries for reports.
• Responsible for designing, creating and deploying reports in SSRS; to include new reports and the conversion of Crystal Reports
• Monitored and handled issues with replication and Change Data Capture between instances of the SQL servers.
• Responsible for administration/implementation/troubleshooting of the Microsoft Dynamics ERP system, using a SQL Server
• Experienced with SSAS server, developing cubes/dimensions for the datamart project for integration with SSRS reports.
• Duties included maintenance / optimization of the Data Warehouse, to include data ETL, data refresh, etc.
• Participated in inter-departmental communications and gathered user requirements with strong verbal and written skills.

Confidential, Dallas, TX

Senior Database Developer / DBA

Responsibilities:

• Support 24x7 online Bill-payment Web applications and Web Services using a SQL Server backend.
• Involved in the on-going project for DTS to SSIS conversions, with strong VB-script skills as part of SSIS development.
• Troubleshoot and correct any SQL-based application issues related to the bill payment process in the Production environment, including modification and optimization of Stored procedures, DTS, SSIS, and SSRS packages.
• Performed performance tuning and optimization of Stored Procedures and data transfers for use in the ETL process.
• Design / troubleshoot /upgrade DTS and SSIS packages for imports, payment processing, bank settlements, and reporting to increase performance and throughput using Visual Studio, SSMS, and DTS Designer.
• Support of Disaster Recovery implementations using Transactional Replication and Mirroring
• Responsible for product installation, updates, patches, database configuration, and security on the Production servers.
• Perform code promotion and versioning using Microsoft Visual SourceSafe and TFS.
• Perform production deployments of stored procedures, databases & tables, DTS & SSIS packages, and SQL jobs.
• Monitor/assist in the backup/recovery operations of the SQL servers as needed.
• Participate in an On-call DBA rotation.
• Experienced with ITIL Change Management procedures within a PCI-compliant software development environment.

Confidential, Carrollton, TX

MSSQL DBA

Responsibilities:

• Performed Database Server administration/maintenance on SQL 2005 and SQL 2000 servers within a Windows Server 2003 environment within a multi-domain, high-availability, 24x7 production environment.
• Responsible for maintaining large databases serving as the data repository for web-based applications.
• Duties include database design and modification, performance tuning, mirroring, log-shipping, replication and clustering to ensure high availablity within the SLA requirements.
• Responsible for backup/recovery operations of all servers using SQL Backup and Redgate.
• Responsible for writing/modifying Stored Procedures, Triggers, Indexes, and SQL jobs, with use of DTS packages.