SUMMARY

• Over 10+ years of professional work experience in RDBMS design & modeling, development, implementation, administration, performance tuning & monitoring; work experience spans across financial services, Mortgage, Federal Government projects and Healthcare Insurance domains on multi large - scale and highly visible projects. Experienced in SQL Server versions: 2016, 2014, 2012, 2008, 2008R2, 2005, 2000, 7.0 & 6.5
• Microsoft Certified Professional, Microsoft Technology Specialist (SQL Server 2005), MCITP: Database Administrator (SQL Server 2008).
• Experience as a MS SQL SERVER Database Administrator in Design, Development, Administration and Management using SQL Server 2016, 2014/2012/2008 R 2/2008/2005/2000 under WINDOWS environments on a 24x7 large scale production environments in a Clustered (2-node/3-node, active/active and active/passive) & non-clustered builds.
• Managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
• Expertise in installing SQL Server 2000/2005/2008 R2,2012, 2014 and 2016 instances and applying service packs and hot fixes using Slip Streams with minimal production downtime.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage.
• Have knowledge in Migration of SQL databases from on-Premise to Microsoft Cloud Platforms (SQL Azure).
• Experience with large scale migrations projects involving Analysis Services databases from SQL Server 2000/2005 to SQL 2008/2008R2& SQL Server 2008 to SQL Server 2012/2014& SQL Server 2012/2014 to SQL Server 2016.
• Provided Architectural design for engineering data unit and launched an ETL application for converting legacy data structures and mapping them to SQL table structures from Oracle Applications.
• Experience in developing Capacity Planning Reports (database growth estimation and Server disk space) and involved in SQL Server Consolidation projects.

TECHNICAL SKILLS

• MS SQL Server 2016, 2014/2012/2208 R 2/2005/2000/7.0/6.5, High Availability Solutions(AlwaysOn, Clustering, Replication, Database Mirroring and Log Shipping), MS SQL Reporting Services(SSRS) 2005/2008R2, MS SQL Server Analysis Services(SSAS) 2008R2/2005/2000, MS SQL Server Integration Services(SSIS) 2005/2008R2, DTS Packages, Erwin Designer 2000, MS-Access 2010/2007/2003, Oracle 9i& 10g, DB2, Windows NT, Windows Server 2008/2000, Windows XP/Windows 7, Unix, Shell script, VB Script, C/C++, HTML, XML, MQ Web Services, UML, MS Visio, MS office 2010, Microsoft Visual Source Safe, Subversion, Microsoft Team Foundation Server(TFS), Window SharePoint Services 3.0., i3 Performance Monitor, SQL Lite Speed, Redgate SQL Compare Utility.

PROFESSIONAL EXPERIENCE

Confidential, Little Rock, AR

Sr. SQL Database Administrator

Responsibilities:

• Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2 R2/2005 .
• Migrated servers from and with In-place and Side-by-Side Processes.
• Worked on Active/Passive clusters to manage cluster resources and troubleshoot errors. Used log shipping, Always on Availability Groups and Mirroring for synchronization of databases and worked with Transactional Replication to achieve load balancing.
• Knowledge of SQL Azure- (Azure Data Studio) cloud implementations and Migrations.
• Experience working with Azure SQL Database Import and Export Service
• Experienced with Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Experienced with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Experienced with using SQL Server tools such as Profiler SSMS, SSCM, DMVs and system stored procedures.
• Knowledge of best & standard practices for setting up data sync from SQL Azure (cloud) to On premise databases for Reporting and data warehousing purpose.
• Experienced with System Administration for Windows 2008, 2016 R2, and 2016 Servers.
• Deployed SQL Server databases in Virtual Environments using Hyper-V and VMware.
• Experienced with using 3rd party DBA tools such as LiteSpeed, RedGate, and IDERA.

Confidential, Denver, Colorado

Microsoft SQL Database Administrator

Responsibilities:

• Architecting & implementing enterprise & business segment OLTP solutions
• Created Fail-over Cluster (Active/Active, Active/Passive) environments, depending on the application and business requirements.
• Implemented and configured AlwaysOn High Availability Solution. Configured Availability Groups and Tested different scenarios of Failover. Configured permissions on AG’s.
• Monitoring and making recommendations for performance improvement in hosted databases which involved index creation, index removal, index modification, file group modifications, code optimization and adding scheduled jobs to re-index and update statistics in databases.
• Create the clustered/non-clustered indexes on tables; created views, store procedures and triggers. Trace out for ant table required any indexes and determine the type of index on it.
• Worked on virtualization platform, determining the location of guest nodes, Performance, licensing.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2008 to MS SQL Server 2012/14.
• Established data architecture and BI best practices, standards and data models, recommended data warehouse and reporting performance tuning techniques.
• Created virtualized Failover Clusters, create the virtual machine, install windows on the VMs, create a domain controller and ISCSI target, and configure the cluster nodes. Finishing the windows configuration and cluster.
• Managed approximately 300 SQL Servers (2008R2 and 2012/2014) with team of 5 DBAs in 24x7 production environment, provided on-call & day-to-day support.
• Installed and Configured SQL Server 2 and 32 bit) on Standalone and Microsoft Clustered servers and applied service packs and hot fixes using Slip Streams with minimal production downtime.
• Upgraded approximately 300 Servers from SQL Server 2008 to SQL 2012/2014 Server, with database sizes ranging from 100GB to 1.5TB.

Environment: 2-node Clustered SQL server 2014/2012/2008 R2/2008/2005, Active-Active& Active-Passive Clustering, Windows 2012/2008R2/2008/2003, Transactional Replication, PowerShell, i3 Performance Monitoring Tool, Upgrade Advisor, SQL Profiler, Performance Monitor, DMV’s, T-SQL, SSIS, VB.NET 2003/2005, and JAVA, FTP/SFTP.

Confidential, Broomfield, Colorado

Database Administrator/ETL Developer

Responsibilities:

• Designed and implemented a data transaction replication to move data transactions from oracle database to SQL and Sybase using stored procedures and coding
• Architected and maintained Erwin logical and physical data models of the data warehouse and data marts.
• Assigned to Enterprise Database and warehouse projects responsible for data research/Analysis/metadata definition/data mapping and logical and physical data modeling.
• Depending upon the application requirement, and the size of the databases, used both Side-by-Side and In-place migration methodologies.
• Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques.
• Upgraded SQL 7.0/2000/2005 Servers to SQL 2008/2012 Server, 60+ production databases, with database sizes ranging from 100GB to 1.5TB.
• Installed and Configured SQL Server 20 and 32 bit) on Standalone and Microsoft Clustered servers and Applied the latest Service Packs, Hot fixes and security patches.
• Managing performance with multiple instances, uninstalling a failover clustering instance, changing the IP address of a failover clustering instance, renaming a failover clustering instance, patching a SQL Server 2008 failover clustering instance

Environment: Clustered SQL server 2000/20 servers, Windows server 2003 R2, Enterprise x64 Edition Service packs 2, OLAP, Transactional Replication, Failover Clustering, SQL Lite Speed V4.8, HP Open view, DTS Exchange, RML Utilities, Upgrade Advisor, SQL Profiler, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SSAS, Informatica, VB.NET 2003/2005, Erwin 4.0.

Confidential, Kansas, Kansas

Database Analyst/SQL Database Administrator

Responsibilities:

• Installing and Configuring SQL Server 20 and 32 bit) on Standalone and Microsoft Clustered servers.
• Applying latest Service Packs and Hot fixes and Upgrading SQL Server 2000 to SQL Server 2005/2008.
• Architecting the solutions by using SQL Server and mentoring developers.
• Implementing T-SQL Coding Standards and writing policies and procedures for data management.
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2008 .
• Writing & tuning Stored Procedures, Functions, Triggers and Views in Transact - SQL for optimal performance.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Involved in Installation and designing MS SQL 2000/2005/2008, created various databases for Development and Testing Environment using SQL Server 2000/2005/2008 and managed database locations and size.
• Used Erwin data modeling tool for creating the logical and physical data models and for forward and Reverse engineering and also used the feature complete model comparison for making the data models synchronized.
• Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions.
• Created complex triggers on tables for logging the data, wrote complex queries and joins as per the business requirements.
• Developed and designed SSIS packages for importing the data from ODBC sources, MS Access, MS Excel, flat files etc.
• Involved in migrating DTS packages to SQL Server 2005 Integration services packages.

Environment: SQL Server 2000/20 R2, Oracle, Windows 2000/2003.2008 server, Query Analyzer, SQL Profiler, Enterprise Manager, SQL Server Configuration Manager, T-SQL, DTS,SSIS, SQL Server Reporting Services (SSRS), SSAS, Windows SharePoint Services 3.0, VB.NET 2003/2005, ASP.NET, SQL Services, Erwin 4.0, ER Studio.