OBJECTIVE:

• Over 5+ of years experienced in Microsoft SQL Server Database Administrator (DBA). Excellent working experience with different company and different environment.
• I have highly trained and knowledge on installation, upgrading, database maintenance, and high availability (AAG) and systems performances with best practices.
• Look for a full time permanent or contract SQL Server DBA position, where I can contribute my knowledge and experience to job done.
• Installation, Configuration and Administration of SQL Server in Production and non - production environment SQL Server 2016/2014/2012 and 2008R2/2008
• Installing, Configuring and Administering SQL Server on Linux
• Working on all Recovery models including Recovery Point Objective (RPO) and Recovery Time Objective (RTO).
• Provide support (24×7) on production environment
• Installing Configuring Oracle database 11g and 12c on Linux operating System
• Perform Oracle hot & cold backup
• Installing configure VM virtualization/Hyper-V and Configure windows Server
• Working experience on Conceptual, Logical and Physical Data Modeling
• Solid experience on Backward & Forward Engineering
• Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools
• Monitor Server Activity, Error Log, space usage, and solving problem as needed
• Excellent experience on Red Gate, Idera, SolarWinds and Fog light SQL Diagnostic Manager
• Strong knowledge and experience in configuring and administering High Availability Solutions like Database Mirroring, Replication, Log shipping
• Solid experience in windows Clustering/SQL Cluster install & configure Active/Active and Active/Passive and Experience on multi node SQL Server Clustering
• Excellent experience Configured on AlwaysOn high availability groups
• Good working experience on SSIS and DTS creating and developed package for data move and manipulation
• Excellent experience on SQL Server Reporting Services, using SQL/T-SQL Scripting for customized Report Generation and Management
• Create, manage and maintain manual and automation jobs.
• Deployed databases scripts on development, test and production environment
• Experience managed SQL server Security, database Security and Audit specification
• Used RPO and RTO to recovery data as per company SLA.
• Applied Service Pack (SP) periodically to production and non-production server.
• Migrated databases from Oracle, MS Access, Excel, FoxPro, MySQL, PostgreSQL and Sybase to SQL Server 2008R2 and 2012
• Upgraded SQL Server 2000 to SQL Server 2005, and SQL Server 2005 to SQL Server 2008R2, and SQL Server 2012 to 2014
• Excellent experience configuring Database Mail Server for database notify alert
• Experience and knowledge on AD (Active Directory), GP and monitor user
• Excellent verbal and writing communication skills to Communicate with developer, co-worker and management team.
• Experience in installing and configuring MySQL database and backup restore.
• Experience install configure PostgreSQL database and backup restore use PgAdmin.
• Experience in Installing and Configuring SharePoint server and Perform database, site backup and restore

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows 2007/2008, Windows Server 2008R2, Windows Server 2012R2

Software / Applications/Tools: MS Project, MS Visio, SQL Server Management Studio (SSMS), Query Analyzer, MySQL Workbench, MySQL Front, SQL Profiler, Business Intelligence Development Studio (BIDS), Congo’s, SharePoint, Red gate, Toad, Idera, Fog light, Data masking, JIRA, Citrix, STIG, Zip4, Remedy.

Programming Languages and Scripts: SQL, T- SQL, XML

PROFESSIONAL EXPERIENCE

Confidential, Vienna, VA

SQL Server DBA

Responsibilities:

• Installed, Configured and Managed SQL Server 2016, 2014,2012,2008 R2 and 2008 in development, test and production environment
• Create backup strategy for production and non-production enclave.
• Configured automation backup jobs.
• Working on all Recovery models including Recovery Point Objective (RPO) and Recovery Time Objective (RTO).
• Monitoring and Tuning for Instance, Database and SQL Query lock, Block, deadlock execution plan, Database Index fragmentation
• Monitor Server Activity, Error Log, space usage, and solving problem as needed
• Excellent experience on Red Gate and Idera SQL Diagnostic Manager
• Upgrade SQL Server 2008 R2 to SQL Server 2012 and SQL Server 2014
• Working experience on Conceptual, Logical and Physical Data Modeling
• Logical and Physical Data Modeling using Tools - Toad Data Modeller.
• Created and managed Database, table, Store procedure, Schema, Indexes and Constraints.
• Installed, Configured and Maintained Database Mirroring including automatic failover option
• Configured Log Shipping as Standby database for Reporting purposes
• Configure SQL Server Replication
• Configured failover Windows Clustering and SQL Server Cluster
• Configured AlwaysON group as DR solutions
• Used Point-in-Time Recovery options to recover data up crush point
• Involved database security and integrity
• Troubleshoot different error/issues on jobs, backups, database health, disk space, maintenance plan, backup verification
• Used DBCC to check database integrity, fix database corruption, rebuild/reorganize indexes and other database Maintenance purposes as well
• Writing T-SQL/PL-SQL and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Created dashboard for quick and drill down reports, defined rules for sensitive, classified and non-classified data
• Alerts on changes or leaks to help ensure data integrity, monitoring and real time security policies protect data across the enterprise
• Monitor data access in real time
• Experience TDE (transparent data encryption) and Mask Data
• Migration of data from Oracle, MS Access, Excel, FoxPro, MySQL, PostgreSQL and Sybase to SQL Server 2008R2 and 2012
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP. Export & Import data from/to databases like Oracle, MySQL, and Access to/from MSSQL Server
• SSIS Package create, deploy and manage, Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed Reports for different purposes like Ad hoc Reports
• Deployed Reports and managed security of report server including folder level
• Installing and Configuring Oracle database 11g and 12c on Linux
• Installed and configure PostgreSQL and MySQL database as a supporting Dba

Work Environment: SQL Server 2016, 2014, 2012 and 2008 R2. Microsoft Azure, Windows Server 2012, 2008 R2 and 2003 R2, IIS (7.5, 6.5), ASP, ASP.net

Confidential, Richmond, VA

Data Analyst/SQL Database Administrator

Responsibilities:

• Installed and Configured SQL Server 2005, 2008/R2 and 2012
• Configured Operating System, Windows Server (2008/2012r2)
• Installing VM workstation and configure windows server
• Upgraded earlier versions of SQL Server 2005 to SQL Server 2008, and SQL Server 2008/R2 to SQL Server 2012
• Installing and Configuring Oracle database Server
• Working experience in RMAN Backup recovery terminology include HOT & COLD backup
• Rebuild Servers (Restore & Recover) from backups.
• Install SharePoint database server and SharePoint reporting server
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping
• Experience in failover windows Clustering/SQL Cluster configure and AlwaysON high availability groups
• Run SQL Script, write T-SQL/PL-SQL and creating Triggers, Stored-Procedures
• Worked with developers to tune-up performance of SQL and T-SQL query
• Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools
• Monitor Server Activity, Error Log, space usage, and solving problem as needed
• Excellent experience on SolarWinds and Fog light SQL Diagnostic Manager
• Created and managed database security, data encryption, and applied object level security
• Setup and configured Database mail for notification purposes
• Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs
• Used DMV (Dynamic Management View) for different database Administration tasks like find backup history, indexes fragmentation, statistics, and status of different jobs
• Extensive experience in using SSIS/DTS, BCP to import & export data from flat files, excel, MS Access, and Other OLEDB databases to MS SQL Server databases

Confidential, Silver Spring, MD

SQL Server Database Administrator

Responsibilities:

• Applied Database STIG on different versions of SQL Database
• Holds well knowledge on STIG
• Performed server installation and configurations for SQL Server 2008r2, 2008 and SQL Server 2005
• Migrated and Upgraded from SQL Server 2005 to 2008 R2
• Installed and Configured database software, and other associated database tools
• Worked on performance monitoring and tuning
• Worked on database design using Toad Data Modeller and also worked closely with BA team for information gathering
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Customized support for Client’s Applications and provided client will win the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
• Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.
• Set up security and access profiles and procedures for database system administrators.
• Implemented MS SQL Cluster (Active/Passive) Multi Node Cluster
• Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
• Managed security by defining roles and rights.
• Monitored the database server performance and if required go for tuning of the DMV, T-SQL queries, Stored procedures.