PROFESSIONAL SUMMARY:

• Microsoft certified SQL Server Database Administrator with six years of professional experience in different Microsoft products.
• As a DBA professional and troubleshooting experience include SQL Server database administration, data modeling, gathering and analyzing business requirement and Operating Systems. Solid working experience in managing large databases, backup/recovery, high availability solution like Mirroring, Log shipping, Replication and SQL Failover Cluster and AlwaysOn, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc.
• Working experience entails strong knowledge on using database third party tools like OpNet, SolarWinds, Idera, ERWin, Visio, and Toad Data Modeler.
• Migrated and Managed SQL databases in Azure Cloud Environment include SQL Server, Azure SQL, setup instance, develop and manage databases
• Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.

TECHNICAL SKILLS:

Databases: SQL Server 2016, 2014, 2012, 2008R2, 2005, 2000, MS Access, MySQL and Oracle.

Database Tools: Profiler, Database Tuning Advisor, Execution Plan, Query Analyzer, SSMS, SSIS, SSRS

Reports Development/Management: SSRS (SQL Server Reporting Services) - Enterprise Reporting

Data Modeling: Toad Data Modeler, ERWin, SSDD (SQL Server Database Diagram.)

Programming: SQL, T-SQL, Scripting, debugging, improved performance stored procedures, Functions, Triggers

SSIS/DTS: DTS, SSIS Package create, manage, deploy, upgrade and migrate packages

Performance Tuning tools: Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, Windows Performance Monitor, SpotLite, Idera SQL Diagnostic

Database High Availability: Strong knowledge and experience in configuring and administering High Availability Database Solutions like Database Mirroring, Always On, Replication, Log shipping, Cluster Database

Windows Server and Active Directory: Experience in administering Windows Server 2012, 2008 R2, 2003 R2, AD (Active Directory), Domain, monitoring user activities, VMware

Large Database/VLDB: Proven ability to handle Database of more than 3 TB in Size

Security: Experience with Security and Audit Management like Security, Encryption, TDE (Transparent Data Encryption)

Upgrade/Migrate: Migrated Oracle, MySQL, Sybase to SQL Server and Upgraded databases from 2005, 2008 R2, 2012 to higher version

Application Server: Administered IIS application server, deployed applications

Service Pack: Applied Service Pack (SP) and hot fixes for Databases and Operating Systems

Documentation: CHM, HTML, DOC, DOCX and PDF format

Third Party Tools: Idera, SpotLite, Erwin, Visio, Toad Data Modeler, and Toad for SQL Server Admin

Web Technologies: SQL, T-SQL, PL/SQL, XML, HTML, VBScript, ASP, .Net Technologies VB. NET, ASP.NET

Development Tools: Visual Studio (VB), Visual Studio2010/2012, BIDS, SSDT

Networking: Active Directory, TCP/IP, Network Switches, Network Hubs, Network Printer.

Hardware/Storage: SAN, RAID

Ticketing Tools: BMC Footprint, ServiceNow, JIRA.

Cloud/Azure: Azure Services, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure

EMPLOYMENT HISTORY:

Confidential, Livonia, MI

SQL Database Administrator

Responsibilities:

• Development, Test and Production environments.
• Installed, Configured, maintained and Administered SQL Server, MySQL and Report Server
• Administration includes SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016and MySQL 5.0.3, 5.5, 6.5
• Installed, Configured and Managed Database Mirroring, Replication and Log Shipping.
• Installed, Configured and Maintained Fail-Over Cluster Servers in SQL Server 2012 & 2014.
• Installed, Configured, Managed and Troubleshot Always On in SQL Server 2012, 2014 & 2016
• Upgraded SQL Server 2008 R2 and 2012to SQL Server 2014 and 2016
• Applied Service Pack (SP) and Hot Fixes to address upgrade and security related issues.
• Migrated on premises databases and Legacy products on Azure
• Wrote SQL, T-SQL queries, Stored-Procedures and Triggers.
• OptimizeSQL queries, Stored Procedures and Functions
• Created and managed Index (Cluster/Non-Cluster), Constraints.
• Monitor Server Activity and solving problem as needed.
• Perform database monitoring, performance tuning, index and statistics management.
• Monitor Servers activity and work with clients to solve different problems.
• Manage SQL Server Error Logs, space usage and growth pattern.
• Manage DEADLOCK, BLOCK and LOCK.
• Worked on different Data Modeling projects including ERWin, Toad Data Modeler on designing Logical & Physical Database.
• Used Backward & Forward Engineering to create Logical and Physical database.
• Created and Managed users, roles, security at object level, data encryption.
• Working experience and strong knowledge in disaster recovery.
• Restore and Recover databases using backups.
• Manual, on Demand and setup jobs for Database Backup, and design backup strategy
• Deployed and Restored database including Point in Time Recovery.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS.)
• Developed Reports using SSRS.
• Developed Ad-hoc Reports using Report Builder.
• Deployed Reports and managed security for reports.

Confidential, Alexandria, VA

SQL Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2016, 2014, 2012, 2008 R2 in development, test, and production environment
• Installed & Configured SQL Server Reporting Services (SSRS)
• Deployed Reports
• Developed Ad-hoc Reports using SSRS
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2012
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008 R2 & 2012
• Configured and Maintained Replications (Transactional)
• Configured and Maintained AlwaysOn in SQL Server 2016
• SQL Server
• SQL Server 2008R2 to SQL Server 2014 and 2012
• Oracle 10g databases to SQL Server 2012
• My-SQL 5.0.1 databases to SQL Server 2012
• Backward & Forward Engineering with data modeling
• Applied SP (Service Pack) on SQL Server 2012
• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Monitor SQL Server Error Log, space usage
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS,
• Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
• Transfer logins
• Experienced with Point-in-Time Recovery
• Restored Database from backup

Confidential, Washington, DC

SQL Database Administrator/SQL DBA

Responsibilities:

• Installed, Configured and Maintained AlwaysOn High Availability Group using SQL Server 2012.Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008. Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.
• SQL Server SQL Server 2005 and 2008 R2 to SQL Server 2012
• Migrated MS Access 2003/2005/2008 R2 databases into MS SQL Server. Migrated Oracle 10g, MySQL, Sybase database into MS SQL Server 2012.
• Worked on more than 10 data modeling projects and generated E-R Diagram. Data Mode3ling tools used using SQL Server Data Diagram.
• Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. Monitor SQL Server Error Log, space usage.
• Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.
• Data from Oracle and SQL Server Excel and setup and performed ETL data load from Oracle and other flat files like text, Excel, and CSV files
• Proficient in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored Database from backup.
• Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder 3.0, 2.0.
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well.

Work Environment: Windows Server2008 R2, 2003 R2, SQL Server 2012, OpeNet, DotNet, AD (Active Directory), applications: Registration System, Reporting System, Booking System, Time Sheet, and Payroll& HR.