PROFESSIONAL SUMMARY:

• Microsoft certified SQL Server D Confidential base Administrator with more than 7 years of professional experience in different Microsoft products.
• Experience in optimizing SQL Server d Confidential base administration, d Confidential modeling, gathering and analyzing business requirement and Operating Systems.
• Solid working experience in managing large d Confidential bases, backup/recovery, developing Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc.
• Cloud/Azure experience includes Azure Services, PaaS, IaaS, and Migrated on premises d Confidential bases and Legacy d Confidential bases to
• Azure, deployed products on Azure, Setup development and test environment on Azure
• Experience also includes strong knowledge on using d Confidential base third party tools like Toad D Confidential Modeler, SolarWinds,
• ERWin, Idera, Visio, and OpNetStrong 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 SKILL:

D Confidential base Expertise: SQL Server 2014, 2012, 2008 R2, 2005, 2000, MS Access

D Confidential base Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, VMware

Languages: SQL, T - SQL, HTML, DHTML, XML, JavaScript, ASP, ASP.net

Cloud/Azure: Azure Services, PaaS, IaaS, Migrated on premises d Confidential bases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure

ETL/D Confidential Warehouse Tools: SSIS/DTS, BCP

Reporting: SSRS (SQL Server Reporting Services) - Enterprise Reporting

D Confidential Modeling Tools: ERWin, Toad D Confidential Modeler, Visio, SSDD (SQL Server D Confidential base Diagram)

Third Party Tools: SolarWinds, OpNet, RedGate, Idera, ERWin, Visio, Toad D Confidential Modeler

Domain/AD: Active Directory, DNS

Hardware/Storage: SAN, RAID, iSCSI

Ticketing Tools: BMC Footprint, ServiceNow, JIRA.

PROFESSIONAL EXPERIENCE:

Confidential

SQL serverAdministrator

Responsibilities:

• Installation and Maintenance of SQL Server 2012/2008 R2/2005 on Test, Development and Production Environments. Install, migrate SQL Server d Confidential base and schemas into a physical and Virtual Machine environment.
• Upgraded d Confidential bases from SQL Server 2005 to SQL Server 2008 and . Migrated d Confidential from Oracle and MY SQL to SQL Server using SSMA. Migrated DTS packages to SSIS packages and maintained the archival d Confidential.
• Migrated on premises d Confidential bases and Legacy products on Azure
• Configured Mirroring, Replication as a DR Solutions. Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003.
• Usage of native tools D Confidential tuning advisor, Profiler and Activity monitor for performance analysis. Create and Maintaining D Confidential base Maintenance Tasks, including D Confidential base Consistency Check.
• Restore and recover d Confidential base using backups, manual and on demand job set up for d Confidential base backup, and design backup strategy. Deployed and restored d Confidential base including point in time recovery.
• Index Update Statistics and Backups. Create and Maintaining D Confidential bases across Development and Production Instances. Analyzing and Monitoring Disk Space Issues, on Test and Production Servers. Performing D Confidential base Refresh from Production to Test, in part of monthly activities.
• Designed and implemented comprehensive Backup plan and disaster recovery Plan. Also, recovered the System and User d Confidential bases from suspect mode. Involved in Capacity Planning, D Confidential base Normalization and De - normalization process.
• Monitoring and performance tuning-Implemented the new SQL Server concepts D Confidential partitioning, Snap shot isolation, d Confidential base mirroring, d Confidential base snapshot, DDL triggers, try-cache blocks, online indexing, DMV s, DMF s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection and Compressed Backups. Monitoring user s permissions and space issues on Production and handling maintenance Jobs including backups and restores. Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Security Management- Created and managed user s roles, security at object level and d Confidential encryption.
• Reports- Installed, configured and administrated SQL server reporting services(SSRS), developed Ad-hoc Reports using report builder. Deployed and managed security of reports.
• D Confidential base Heath Check- Checking D Confidential base Health by using DBCC Commands and DMVS. Also, hands on experience in trouble shooting d Confidential base issues. Update statistics, and d Confidential base integrity. Monitoring SQL server performance using profiler for identifying performance issues. Lock, bloPerformance using execution plans and Index tuning.

Environment: MS SQL Server 2012/20 bit, Enterprise, Windows server 20 bit, SSIS, SSRS, Activity Monitor, IIS, SQL Agent, Idera, SQL Profiler, MS Excel.

Confidential, Washington DC

SQL Administrator/SQL DBA

Responsibilities:

• Developed & maintained scripts, utility jobs or implement needed software for d Confidential base maintenance.
• Implemented & managed d Confidential base clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust d Confidential base backup and recovery strategy with client assistance.
• Customized support for Client’s Applications and creating and maintaining d Confidential base objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
• Monitored d Confidential activities such as d Confidential base status, logs, space utilization, extents, Checkpoints, locks and long transactions.
• Migrated and Upgraded from SQL Server /2008 R2
• Configured d Confidential base software, associated d Confidential base tools and performance monitoring software.
• Performed d Confidential base/infrastructure physical design, d Confidential base upgrades & applied software patches to d Confidential bases as per application/client requirements.
• Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum d Confidential base 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 d Confidential base system administrators.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
• Handled Logical D Confidential and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
• Created, administered & maintained SQL Server D Confidential bases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for D Confidential base and Applications.
• Monitored the d Confidential base server performance and if required go for tuning of the TSQL queries, Stored procedures.
• Working individually, as a member of a team, and lead small teams to collaboratively design and model systems at a high level prior to construction

Confidential, Washington DC

SQL base Administrator/SQL DBA

Responsibilities:

• Configured, Installed, and Maintained SQL Server 2000 & 2005 in development, test, and production environment
• Installed and Configured Operating Systems, Windows Server (2000 & 2003)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications, Log Shipping
• Upgraded d Confidential bases from SQL Server 7.0/ in testing and production environment
• Upgraded MS Access 2000/97 d Confidential bases into MS SQL Server 2000, and 2005
• Backward & Forward Engineering with d Confidential modeling tools mentioned above
• Export & Import d Confidential from Flat file, CSV file, Oracle, and Access to/from SQL Server D Confidential base using DTS, SSIS, and BCP
• Generated Report using SSRS and in Excel, html, text from D Confidential base as well
• Working experience in D Confidential base Backup, Restore and Point-in-Time Recovery
• Scheduled jobs to automate different d Confidential base related activities including backup, monitoring d Confidential base health, disk space, backup verification
• Developed Different Maintenance Plans for d Confidential base monitoring
• Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition
• Expertise in d Confidential base Performance tuning
• Writing T-SQL and Stored-Procedures
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• D Confidential Modeling, developing E-R Diagram using ERWin and SQL Server D Confidential Diagram
• Monitor Server Activity, Error Log, space usage, and solving problem as needed