TECHNICAL OVERVIEW:

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

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• 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

Sr. Database Administration Consultant

Confidential

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Confidential

Database Analyst

Responsibilities:

• 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