Yyyyyy x. yyyyyy

4545 Spring Canyon Hts, #0000 xxxxxx xxxx , xxxx , xxxxx 00000 xxx-xxx-xxxx ● abc@xyz.com

Query Writing ~ Stored Procedures ~ Scrum / Agile Process

Replication ~ Migrations ~ Performance Tuning ~ Business Intelligence

         Outstanding expertise in data mirroring, log shipping, performance tuning, query optimization, and ensuring rigorous data integrity in machine-critical and high-volume Terabyte database environments.

         Proficiency with SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), and SSAS (SQL Server Analysis Services).

         Constantly focus on optimizing application performance, reliability, security, and usability.

• Expert at creating triggers, objects, views, stored procedures, and databases using T-SQL and PowerShell.
• Solid ability to extract, manipulate, and analyze complex data to generate detailed reports

         Efficiently balance competing demands, resolve technical challenges, and master new technologies.

Summit Utilities Inc., Littleton, CO, Jan 2015 Present

DBA II

         Apply strong technical expertise toward playing an integral role in Cayenta ERP implementation.

         Employ SolarWinds to investigate performance issues with Cayenta, decisively select new monitoring vendor, and contribute to development of customer self-service module within application.

         Spearhead upgrade of SQL Server 2005 to SQL Server 2008 R2 and subsequently to SQL 2012.

         Perform thorough database disaster recovery testing via Abtech and AppAssure tools.

         Configure replication for GIS and leverage SQL queries to facilitate performing tuning and optimization.

         Accurately compile technical documentation associated with merger of Summit Utilities and AOG.

City and County of Denver, Denver, CO, Sep 2014 Jan 2014

SQL DBA

         Partnered with project manager and business analyst to seamlessly migrate 12 DTS packages (written in Sybase SQL Anywhere and SQL Server 2000) to SQL Server 2012 SSIS packages for Denver Police Department s TeleStaff ERP system.

City and County of Denver, Denver, CO, Mar 2014 Jul 2014

SQL DBA

         Collaboratively migrated data from Hatrack systems for Sheriff s Office (Criminal Justice Information Systems) to Atlas (Emerald City ERP system) running on SQL Server 2008 R2.

         Exclusively supported and maintained SQL Server 2005, 2008, 2008 R2, and SQL 2012.

         Governed capacity planning in conjunction with Infrastructure group, and maintained enterprise production SQL server environments including MS SQL failover clusters and replication.

         Joined forces with Integration, Reporting, and Operations teams to plan and execute new initiatives.

         Closely monitored performance of SQL Server to collect custom metrics, and advised senior management in continuous improvement where applicable.

Comcast, Greenwood Village, CO, Dec 2013 Jan 2014

Database Administrator

         Successfully led MySQL Server database migration project from installation and configuration, though data migration and performance tuning.

         Demonstrated proficiency in database design, security model design, and database server architecture.

Continued ►

Yyyyyy x. yyyyyy Page 2 of 2

MI-JACK, Chicago, IL, Nov 2013 Dec 2013

SQL DBA

         Performance-tuned database running on DB2 UDB and proactively teamed with offshore resources to swiftly to track, fulfill, and resolve database-related incidents and requests within defined SLAs.

T Systems, Scottsdale, AZ, Jun 2013 Aug 2013

SQL DBA

         Migrated SQL Server 2008 R2/SQL Server 2012, MySQL and DB2 UDB databases to TSYS cloud for global client (DHL) and efficiently transferred DHL s databases to T-System data center.

AirMethods, Centennial, CO, Jun 2012 Dec 2012

System Administrator

         Supported RAMCO ERP (Aviation Module) running on SQL Server 2005, SQL Server 2008 R2 and SQL 2012, as well as pilot 411 system on Oracle 11g.

         Applied patches to SQL Server and performed back-up and restore of training and pre-production environment to ensure rigorous business continuity.

Mercury Payment Systems, Denver, CO, Apr 2012 Jun 2012

SQL DBA / Developer

         Methodically performed database migrations requiring daily participation in Scrum meetings, cohesive relationships with team members, and precise technical documentation.

First Data, Greenwood Village, CO, Feb 2011 Feb 2012

Project Lead / Database Administrator

         Supported and effectively optimized SQL Server databases at geographically-dispersed data centers running on SQL 2005, SQL 2008, and SQL 2008 R2.

         Employed sound leadership skills to direct development of reports using BIDS in SSRS.

         Functioned as SME for SQL Server databases spanning two data centers.

         Installed service packs and patches, created cubes via SSAS, upgraded SQL Server 2005 to SQL 2008 and subsequently to SQL 2008 R2, and performed security hardening of servers as needed.

FedEx, Milwaukee, WI, Jan 2011 Feb 2011

Database Advisor

         Project-managed the complete spectrum of program development via Agile methodology and involving Oracle, SQL Server, and Business Objects software.

OnTargetJobs Inc, Englewood, CO, May 2010 Nov 2010

SQL Database Administrator

         Supported online job boards for Medhunter, Baybio, Regional Help Wanted, and Hcareeers.com.

         Implemented SQL logins, roles, and authentication modes which aligned with defined security policies.

Bachelor of Science in Engineering, Patna University, India

Certifications:

DB2 Database Administration Natural / ADABAS Programming

Oracle 10g Database Administration SQL Server Administration

iSeries, pSeries, zSeries, RS 6000, DB2 UDB ESE/EEE/WSE, SAP R/3 4.6c/4.7, SAP BW 3.5/3.1C/3.0B/2.1C, BW-BPS, SEM, BEX Analyzer, mySAP CRM 4.0, SAPGUI, EAI, BPEL, BAPI, DataJoiner, Sun Solaris, AIX, Linux, Unix, PeopleSoft 8.8/8.4/7.5, Oracle 7/8i/9i, TOAD, Eclipse 3.0, CVS, SQR, Application Designer, OEM, OS/390, CICS, JCL, DB2 Connect, VSAM, AIX, NATURAL, ADABAS, COBOL, COBOL/400,CSP, HTML, Access, SQL Server, BMC, Spotlight, QueryObject , Platinum, Endeavor, ER-Win, Java, Visio, Omegamon, SolarWinds, Caventa ERP