SUMMARY:

• Microsoft Certified MS SQL Server Database Administrator having over 5 (Five) years of working experience in managing large enterprise environments using SQL Server 2016, 2012, 2008 R2, and 2005. My experience entails in Database Design,Azure migration, Architecture, Administration, HA Solutions, Performance Tuning, ETL/ SSIS, Reporting, Monitoring, Performance Tuning, SQL Coding, - Stored procedure, Trigger, Function, and have many years of using third party besides the native tools for Database Design and Administration is looking for Database Admin/DBA job.
• Experienced in Database System Analysis, Design, Implementation and Administration of MS SQL Server2016, 2014, 2012 & 2008R2 in Production, Test, UAT, Staging, & Development.
• Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading, and Migrating SQL Server 2016, 2014, 2012, 2008 R2
• Experienced in Configuring, Managing and Administering Clustering, AlwaysOn, Database Mirroring, Log Shipping & Replication
• T - SQL programming in writing, managing, and debugging TQL, Functions, Stored Procedures, and triggers
• Experienced in Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools and Monitoring Server Activity, Error Log, space usage, and solving problem as needed
• ETL and Data Warehousing using SSIS and DTS
• Database Backups, Jobs, Alerts, Notifications, Security Management (TDE, STIG), Applying SP and Hot fix

TECHNICAL SKILLS:

Database: SQL Server 2016/2014/2012/2008 R2/2008/2005, MySQL(4.0.3, 5.0.1), Sybase, MS Access 2003 & 2000

Tools: Server Management Studio, Enterprise Manager,Business Intelligence Development Studio, QueryAnalyzer, SQL Profiler, SSIS and DTS, Replication,Clustering, Database Tuning Advisor, and Index TuningWizard, BCP, SQLCMD, Reporting Services ReportManager, Reporting Services Configuration and ReportBuilder, Upgrade Advisor, SQL Configuration manager and Service manager

Tools: SSIS/DTS, BCPData Modeling Tools: Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)

PROFESSIONAL EXPERIENCE:

Confidential, Bradenton, FL

SQL Database Administrator

Responsibilities:

• Installed, Configured, and Managed Instances and Databases in SQL Server 2016, 2014, 2012, and 2008R2 in development,, Staging, Test/UAT, and Production Environment.
• Installed, Configured and Maintained HA (High Availability) Solutions - Always On, Failover Clustering, Replications, Mirroring, and Log Shipping
• Installed, Configured, and Managed Instances of SQL Server Reporting Services (SSRS)
• Developed, Deployed and Managed Reports using different data sources like SQL Server, Oracle, Excel, CSV files
• Upgraded/Migrated SQL Server and Reporting Server Instances
• Applied SP (Service Packs) and Hot fixes
• Migrated Databases and Instances
• SQL Server to SQL Server
• Oracle Databases to SQL Server
• MySQL Databases to SQL Server
• MS Access Databases to MS SQL Server
• Monitoring, Troubleshooting Instances, Databases, Queries using different tools
• Query Execution plans
• Database Tuning Advisor
• Server Logs, Agent Logs and Error Logs, Event Logs
• DMV (Dynamic Management View)
• Indexing, Index and Statistics Management
• Developed and Tune-up Queries
• Queries including JOIN, Stored Procedures, Functions, and other queries
• Worked developers to tune-up queries related to performance issues
• Database Design
• Azure migration
• Designed new database systems for applications and redesigned existing database systems
• Designed Relationship, Keys, constraints, indexes, and other constraints for data integrity and performance
• Conceptual, Logical and Physical Design
• Backward and Forward Engineering
• Used native and Third-Party tools - ERWin, Visio, Toad Data Modeler
• Database Architecture - Solid experience on architecting Database Server Instances
• Automations - Create jobs, setup schedules, configure mail server, operators, notifications and other related services
• Database Backup - Designed backup strategies for development,, Staging, Test/UAT, and Production Environment, setup automated backup verification process for backups
• Database Recovery, Refresh and Deployment - Performed Database Recovery, Refresh/Deployment across the environment including Point-In-Time Recovery
• Monitoring database and server health, lock, block, disk, CPU, jobs, and other related services
• ETL Processing
• Installed, Configured, and Managed SSIS (SQL Server Integration Services) Instance
• Developed, Deployed and Managed SSIS Packages using different types of sources such as Database, Flat file, CSV, Excel and OLE DB supporting sources
• Migrated and Upgraded SSIS Packaged
• Setup jobs using SSIS Packages
• Managed security
• Used SSIS packages for many other purposes - Moving logins, databases, data, and for other objects Instance, Databases, and Users Security Management
• Operating System: Windows Server 2012/2008R2/2003/2000, Windows XP/NT4.0, MS-DOSDisaster Recovery:
• (DR Systems)
• Configured and Maintained High Availability solutions like Database Clustering, Always On, Mirroring, Replication, Log shipping
• Languages: SQL, T-SQL, PL/SQL, XML, JavaScript, ASP, ASP.net and C++
• Hardware/Storage: iSCSI, NAS, SAN, RAID, NatAppThird-Party Tools: Double Take, Idera, Spotlight, BMC, JIRA, ServiceNow

Environment: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2016, 2014, 20122008 R2, Applications, Reporting System

Confidential, Mason, OH

SQL DBA

Responsibilities:

• Installed and configured SQL Server 2012 and 2008R2 Enterprise and standard edition in the production/ Development and test environment and applied latest service packs and security fix servers.
• Configured SQL Server Mirroring for High Availability across all production servers in SQL Server 2008 R2.
• Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012 & SQL Server 2014
• Implemented High Availability in SQL 2012 by configuring Always on Availability groups across Windows Server Failover Clusters using Failover Cluster Instances
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Used DMVs to diagnose problems and monitor health of server instance.
• Rebuilding indexes with different fill factors and update statistics manually.
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Installing/administrating SQL Server Reporting Services (SSRS), creating schedule reports and delivering via email.
• Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
• Configured Transactional Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors) and troubleshoot replication issues.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Migrated database from SQL Server 2008 R2 to SQL Server 2012.
• Worked extensively in performance tuning of databases including query tuning, server tuning.
• Created and scheduled maintenance plans for Database backups, log backups and cleanup.
• Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Developing performance tuning and enhancement approaches to improve overall system performance and provide value add to the customer.

Environment: MS SQL Server 2012, 2008 R2, SSIS, SSRS, Replication, Mirroring, DotNet Applications

Confidential, Alexandria, VA

SQL Database Administrator

Responsibilities:

• Responsible for installation and configuration of SQL server 2008R 2/ 2008/2005. Migrating databases from SQL Server 2005 to SQL server 2008.
• Installed SQL Server 2008 in Windows Clustered environment (Active- Passive).
• Managed security logins and worked with Windows authentication, SQL server authentication and mixed modes.
• Configured Database Mirroring with and without a witness server.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment and SQL Server 2005 security Audit.
• Worked on Performance tuning and tweaked SQL queries by adding indexes for better performance.
• Configured data partitioning/table partitioning on large sized tables to improve performance.
• Upgraded SQL Server 2005 to SQL Server 2008R2 and migrated data.
• Designed and developed SSIS packages using different control flow tasks, Transformations, and dataflow task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Setup Transactional Replication from Production Servers to Report Server and created a Reporting Dashboard using SQL Reporting Services.
• Created and altered Stored Procedures to improve security and decrease Server overhead.
• Managed Security
• Created and maintained SQL agent for scheduling jobs, Alerts and Operators

Environment: SQL Server 2008 R2, 2005, Report Builder 3.0, MySQL, VISIO, Idera, VMwareWindows Server 2008 R2, 2003