TECHNICAL SKILLS

Databases: MS SQL Server 6 5/7 0/2000/2005/2008/2012/2014/2016, DB2, Oracle

Languages: T - SQL, XML, VB Script, Power Shell

Software: SCOM, IDERA, Active X, Microsoft Project, Microsoft Visual SourceSafe, Microsoft Visio, Red Gate

Backups: Native SQL, Net Backup, Snapshot Manager for SQL, NetApp Solutions Suite, Red Gate

SUMMARY

• With over 10 years hands-on experience supporting MS SQL Databases
• Understands database design and data management best practices
• Strong database performance analysis skills
• Strong problem triage and remediation skills
• Experience with T-SQL coding and analysis
• Experience using SSAS, SSRS and SSIS
• Experience configuring, supporting and monitoring SQL replication technologies
• Experience with SQL and Windows analysis tools (SSMS, Activity Monitor, SQL Profiler, Perfmon)
• Excellent communication skills and works well with diverse teams or independently
• Experience with the full project lifecycle from conception to implementation & support
• Self-starter with excellent organization, planning, documentation and time management skills
• Ability to analyze business cases, extract requirements and understand business needs
• Proficiency with metadata, data modeling and data quality tools
• Experience with Multi-platform and multi-system integration

Confidential

Sr. Database Administration Consultant at UMB Bank (Contract)

• Business resiliency and disaster recovery project
• Setup/Install/Configure new SQL 2016 Servers and other related software using Powershell scripts (unattended installs)
• Meet with Bank App Clients, understand business process, create service now tickets and perform DB migrations
• Analyze and migrate current banking apps (monetize, frcm, zmdesk, zerobase) running on SQL server 2012/2014 to SQL Server 2016
• Configure/Setup server mount points for SQL data, tempdb and log files
• Setup/configure databases for transact/snapshot replication
• Setup configure databases for high availability/clustering
• Configure databases for log shipping and reporting with Microsoft Dynamics
• Continuous SQL database integration\coding\scripting using native SQL and Red gate
• Setup/manage/configure SQL DataMart/Data Warehousing
• Perform native SQL and Ola Hallengren backups
• Configure SCOM/IDERA/SQLSafe and other SQL monitoring tools
• Test backups for Disaster Recovery and to meet business Recovery Time Objectives (RPO)
• Reconfigure SSIS packages on new SQL 2016 servers
• Maintain complex ETL data flows between varieties of environments
• Performance tuning and deploying database change scripts provided by third party vendors
• Creating and editing stored procedures and views
• Managing database security
• DBA best practices and advisory role and create and maintain documentation for Project
• Work with Oracle team to support Oracle database migrations
• Provide support and troubleshooting for production databases

Confidential

Database Architect (Contract)

• Install\Configure\Manage production SQL 2012\2014\2016 servers in high visibility\availability setting
• Understand client business flow\processes and work with Engineering\DEV\QA teams to implement SQL codes\Resolve DB issues
• Install\configure and manage SQL Server High Availability Services for multi production servers
• Install\configure\Manage\Troubleshoot SQL Cluster Failover Server\Always ON Availability
• Installation, configuring, supporting and monitoring of SQL replication technologies (Both Customized and MS native based)
• Partition and manage multi-terabyte SQL Server tables including sliding windows scenarios
• Patching of production servers with latest MS patches in HA and Clustering SQL Server
• Direct and expedient involvement with service restoration from database related system outages and slowdowns;
• Detailed documentation of all project processes on SharePoint
• Participation in root cause analysis and development of countermeasures for serious database related incidents;
• Proactive monitoring and performance analysis of production SQL databases;
• Development and enhancement of database monitoring and housekeeping utilities as required
• Application development consulting, debugging and tuning of indices, SQL statements including SQL statement creation, SQL statement tuning, and partitioning;
• Direct involvement with application teams to review, develop and analyze DDL, provide and execute deployment scripts, application tuning and maintenance with respect to data base performance;
• Object creation and writing T-SQL functions and queries (index, tables, stored procedures, triggers);
• Database structure creation at schema level; design the databases, tables as per application requirements
• Code deployment to production in cases where app teams do not have credentials to deploy it;
• Management of authorizations and access rights for the application user base;
• Support of data recovery and restores as related to specific applications;
• Tune and resolve database performance problems
• Support DB2 database for business analytics and big data projects
• Effectively manage and monitor all pertinent aspects of RDBMS environments (development, test, and production)

Confidential

Senior Database Administrator

• Perform upgrade of SQL 2000 and 2005 servers to SQL 2008
• Setup SQL Server Clustering
• Create automated database refresh processes with SSIS
• Create automated processes to generate SQL snapshots
• Dedicated Administrator Connection - Guidelines and scripts for emergency access to SQL servers
• Develop DBA standards and best practices Standards include large scale deletes; DBCC CHECKDB; using temp tables; database config; SQL config; standard for data compression
• Develop SQL Data Warehouse for persisting data for performance analysis & unnecessary indexes
• Implement table partitioning
• Research and evaluate new features of SQL 2012: Semantic model and power pivot, extended events, Column store indexes, DQA, MDM, File table, SQL Always ON (HADR), new admin tools, how easy/difficult to upgrade existing databases from 2000, 05, 08, etc
• Work with developers to write more efficient SQL codes and putting a primary key or unique clustered index on every database table
• Server consolidation, updating permission standards and policy based management
• Develop DBA operational standards: Identify needed and available storage for all DBs; automatically identify when indexes need to be added or removed; Identify root causes for outages and implement solutions; automate defrag process
• Automate capacity statistics for all SQL servers, run SQL Best Practices Analyzer against all production databases and evaluate change data capture and change tracking
• Automate database storage projections
• Perform SQL database table compression and review of alerts produced for accuracy and usefulness
• Create SCOM reports for disk space used; index fragmentation; table space and index space report; tables missing primary key/clustered index; last server reboot time report
• Reduce OPEX for supported services including SQL licenses; indirectly NBU licenses and storage): Decommission unused DBs; consolidate SQL servers
• Build SCOM dashboard to monitor DBA operational activities
• Perform Oracle installs and backups
• Support legacy Oracle 9 servers
• 24x7 support of more than 100 SQL Server installations
• Install\Configure\Manage production SQL 6.5\2000\2005\2008\2012 servers
• Install\configure\Manage SQL Cluster Failover Server Clustering (SQL 2008\2012)
• Configuring, supporting and monitoring of SQL replication technologies
• SQL integration and data processing with Data Transformation Services
• Backup solutions using native SQL, Netbackup, BackupExec, Red Gate Technologies
• SQL scripting and coding including DOS and Powershell scripts for various DB automation
• Monitoring solutions with SCOM\Net Suites
• Build in-house custom apps for client database management with dynamic SQL including documentation
• Perform Oracle backups and restores including databases security

Confidential

Database Administrator

• Installing and configuring SQL Server
• Coordinating and implementing SQL Server Upgrades and Service Packs
• Coordinating and implementing Operating System Upgrades and Service Packs
• Retiring and swapping old servers with newly procured servers
• Performance tuning of the SQL Server databases
• Planning the implementation of new hardware and software
• Built/Maintained SQL Jobs
• Built/Maintained SQL Jobs to automate day-to-day operations
• Designed and maintained reporting websites for User Support to gather metrics
• Experienced in Performance Tuning of the SQL Server databases
• Experienced in using Data Transformation Service DTS
• Performing Backups/Restores
• Worked with Corporate Security to secure servers

Confidential

Database Analyst

• Database Administrator using both Oracle and Microsoft SQL Server
• Developed web applications using Microsoft IIS, ASP, and Microsoft Interdev
• Experienced in data modeling for transaction and warehouse database designs
• Designed and maintain corporate website and hosted websites
• Experienced in writing scripts, stored procedures and triggers
• Experienced in creating backup and restore procedures