SUMMARY

• Have strong experience with Azure cloud to maintain SQL database and application and Continue taking classes for learning AWS cloud
• Experienced in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating MS SQL Server 2016, 2014, 2012, 2008 R2, and 2005 on Windows 2008R2, 2012R2 and 2016
• Managing SQL server custom .Net application and granting appropriate permission troubleshoot the user issue and monitor user activities
• Proficient in SQL Server Disaster Recovery, Backup/Restore
• Strong hands on experience of backup and restore, export and import, SSIS and SSRS
• Performed Data Modeling, data analysis, database design, and developing E - R diagram using Erwin, VISIO 2010 and IDERA ER/Studio Database Diagram
• Hands on experience and outstanding knowledge of high availability SQL Server solutions including Mirroring, Log shipping, Replication and have knowledge to Always on Availability Groups.
• Experience in Performance Tuning, Query Optimization, client/Server Connectivity.
• Good knowledge using DMV’s, system tables, system stored procedures to troubleshoot or to find metadata from SQL server.
• Experienced on Execution Plan, SQL Profiler, Index Tuning Wizard and Perf Mon for enhancing availability and troubleshooting performance issues.
• Expertise in Security Issues such as creation and granting permissions on various objects and troubleshoot the issues
• Experience in creating packages, Scheduling Jobs, setting up Alerts & notifications using SQL Mail.
• Migrating databases from SQL server 2005 to SQL Server 2008R2, 2008R2 to 2012 and 2016
• Using DBCC commands that checks database consistency on user databases.
• Experience in implementing RAID technologies to be used with the SQL server database technology
• Good understanding of Normalization /De-normalization and data modeling database design methodology.
• Capable of handling responsibilities independently as well as a proactive team member with strong analytical skills.
• Managed access and troubleshoot MPS, FETSR, Security, RFI, EFCT and PET
• Manage Active Directory user account creation and upload certificate to login the web application and troubleshoot the problems

TECHNICAL SKILLS

Operating Systems: Windows Server 2016R2, 2012 R2, 2008R2

Databases: MS SQL Server 2016, 2014, 2012R2, 2008 R2, 2005, and MS Access

Database Migration: Migrated Databases from SQL Server to SQL Server Migrated Oracle and MySQL Databases to SQL Server

SQL Server Tools: SSMS, SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Client Configuration utility

Third Party Tools: ER/Studio, ERWin, Toad Data Modeler, RedGate and Visio 2010

ETL Tools: SSIS (SQL Server Integration Services) BI

Programming: SQL, T-SQL, Writing Query and Scripts, Store Procedures, Trigger, HTML, ASP, ASP.net

Reporting Tools: SSRS (SQL Server Reporting Services)

Disaster Recovery and High Availability Solutions: Backup & Recovery, Log Shipping, Mirroring, Replication, Always On, and Clustering

Data Security: TDE (Transparent Data Encryption), IPSec, SSL, Data Masking, Column level security

Networking: Active Directory, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Ft Belvoir VA

DBA

Responsibilities:

• Have strong experience with Azure cloud to maintain SQL database and application
• Deliver Migration plan for standalone data center to Azure cloud in production, Dev and Test environment
• Installed, Configured, and Managed SQL Server 2016, 2014 on Windows server 2016 R2 in the Azure Cloud
• Check and apply latest Patch Management: Applied SP (Service Pack) and HOT Fixes on SQL Database Servers
• Upgrade SQL Database from SQL 2012 and 2014 data center to SQL 2016 in the Azure Cloud
• Server and Database Monitoring: Monitored Database Servers, Databases, Agent, Jobs log files
• Monitoring user activities and troubleshoot login issues
• Backup/Recovery: Setup database disaster recovery plan schedule backup using Azure backup
• Create blob storage for database backup and restore for disaster recovery
• Working as Cloud Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, resource groups.
• Remote login to Virtual Machines to troubleshoot, monitor and deploy applications.
• Configuration of Microsoft Production, Dev and Test Labs to migrate the virtual machines from one subscription to another subscription.
• Managing day to day activity of the cloud environment, supporting development teams with their requirements.
• Creating Labs, Virtual Machines along with setting up policies and using Formulas and Custom Images to deploy the network.
• Create SQL VM and install SQL server on windows 2016
• Create Oracle VM and install Oracle server on Linux 7.5
• Monitoring all database and application server space issues
• Monitor Server Activity, and solving problem as needed
• Monitor database and application users daily and take appropriate action
• Support all databases that running with ASP.net custom application
• Serve as Tier 3 service desk escalation support to customers and application owners through ServiceNow ticketing system
• Increase day-to-day operational efficiency and accuracy via the use of automated tools and scripts
• IIS configuration and application server software installation and configuration on windows 2016
• Moved users from source server to destination server using Microsoft rev login script
• Create AD HOC database report, Scripting and managed automatic jobs

Environment: SQL Server 2016 and 2012 (Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), ASP.net Applications, VISIO 2010, Oracle 11g and 12c. IIs Application Server Windows Server 2016 and 2012R2, AD (Active Directory) . Third party Application. SharePoint 2013.

Confidential, Arlington VA

DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2016, 2014, 2012, 2008 R2, & 2005 in Development, Test and Production Servers on Windows server 2016, 2012R2 and 2008R2
• Patch Management: Applied SP (Service Pack) and HOT Fixes on SQL Database Servers
• Database Upgraded: Upgraded from SQL Server 2005, 2008 R2 to SQL 2012 and 2016 side by side method
• SQL database server left and shift from one environment to different environment 2012 to 2016
• Strong experience on SQL database STIG per DISA required using STIG viewer 2.8 for version 2008R2, 2012, 2016
• IIS configuration and application server software installation and configuration on windows 2016
• Moved users from source server to destination server using Microsoft rev login script
• Quarterly SQL database server maintenance and monitor server users activities
• Support all Database server, Application server and Hosted SQL database and Oracle 11G database and Web application
• SQL server database migration from JVE1 environment to JVE2 environments
• Installed and Configured SQL Server Reporting Services (SSRS) in 2008 R2 and 2012
• Database Monitoring: Monitored Database Servers, Databases, Agent, Jobs log files
• Backup/Recovery: Setup jobs and troubleshoot jobs related to backup, Recovered Database in Point-In-Time
• Database mirroring setup and managed for disaster recovery
• Managed SQL database server cluster Active passive instance
• Used DBCC and DMV for different purposes
• Created, Modified, and Managed Indexes (Clustered/Non-Clustered, Simple, Composite), Constraints
• Performance Tuning: Worked on performance tuning to improve performance for different applications, SQL/TSQL code using different Performance tools such as Query Execution plan, Database Tuning Advisor, Profiler.
• Serve as Tier 3 service desk escalation support to customers and application owners through Remedy
• Increase day-to-day operational efficiency and accuracy via the use of automated tools and scripts
• Install, administer and maintain virtual environments and physical hosts.
• Responsible for the administration, troubleshooting and maintenance of Unix/Linux servers and over 30+ Windows Servers in an external Active Directory Windows 7 and windows 2012R2 environment to include Exchange, File Server, DHCP, Retina, Print, SCCM, WSUS, SQL, SMS, SharePoint and VMWare
• Use Remedy ticketing system to provide tier-3 resolution until completed
• Monitoring all database and application server space issues
• Monitor Server Activity, and solving problem as needed
• Monitor database and application users daily and take appropriate action
• Create Maintain internal and external (Foreign) users profile in the SQL database and troubleshoot users login issues
• Troubleshoot database and application related any issues
• Create AD HOC report, Scripting and managed automatic jobs
• Configured schedule Back up of database and Restore the database from Disaster Recovery
• Configure Managed and troubleshot all high availability in SQL Server like Log shipping and Mirroring for Disaster Recovery
• Performed performance using SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers.
• Performance tuning: Performed performance tuning for Server, Database, Query using different tools like Profiler, Execution plans, Perfmon, Counter, Database Tuning Advisor, DMV
• Database Automation: Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, and moving databases from environment to environment including creating test environment, Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
• Troubleshooting: Monitored Server Activity, Error Log, space usage, and solving problem as needed
• Manage Oracle database staging and production server and troubleshoot problems maintain DISA requirement for the STIG
• Deployment in Test, Dev and then Production environment for database new release
• Utilize manual checks, GUI-based, and command line tools (PowerShell) and CMD to troubleshoot and remediate basic to complex systems hardware, software, and configuration issues on assigned systems, networks, Active Directory.
• Participate in or lead special projects and day to day operations as needed or assigned by the site lead, and clearly communicate technical information to both technical and non-technical personnel.
• Administer, distribute, update software, deploy operating systems, apply patches
• Experience in administering Active Directory and create user profile upload PKI certificate and troubleshot issues
• Have experience in the Share Point 2007-2010 administration for Collaboration Sites, Grant access to the external and internal user and troubleshoot the issue

Environment: SQL Server 2016, 2012/2008R2/2008 and 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), ASP.net Applications, VISIO 2010, IIs Application Server Windows Server 2016, 2012R2, 2008R2, 2003, AD (Active Directory) . Third party Application. SharePoint 2007-2013.

Confidential

DBA

Responsibilities:

• Installed and configured SQL Server 2012R2, 2008R2, 2005 on Windows Server 2012R2, 2008R2 and 2003
• Strong experience to migrate SQL server database from 2005 to 2008R2 and 2012R2 in Development, Test and Production environments
• Monitoring all database and application server space issues
• Monitor Server Activity, and solving problem as needed
• Monitor database and application users daily and take appropriate action
• Experience in administering AD (Active Directory)/Domain and monitoring user activities
• Deployment in Test, Dev and then Production environment
• Support all databases that running 14, ASP.net custom application like JSF MPS, JSF Flight Clearance, JSF GPOTS, JSF FTSER, JSF PET, JSF Security etc.
• Support all Database server, Application server and Hosted SQL database and Oracle 11G database and Web application
• Create Maintain internal and external (Foreign) users and troubleshoot users login issues
• Troubleshoot database and application related any issues
• Create AD HOC report, Scripting and managed automatic jobs
• Planned the complete Baking up of database and Restore the database from Disaster Recovery
• Configure Managed and troubleshot all high availability in SQL Server like Log shipping and Mirroring for Disaster Recovery
• Performed database backups, restored database from backup, and developed recovery procedures.
• Performed performance using SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers.
• Performance tuning: Performed performance tuning for Server, Database, Query using different tools like Profiler, Execution plans, Perfmon, Counter, Database Tuning Advisor, DMV
• Database Automation: Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, and moving databases from environment to environment including creating test environment, Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
• Troubleshooting: Monitored Server Activity, Error Log, space usage, and solving problem as needed
• Manage Oracle database staging and production server and troubleshoot problems maintain DISA requirement for the STIG
• Have experience in the Share Point 2007-2010 administration for Collaboration Sites, Grant access to the external and internal user and troubleshoot the issue
• Maintain SQL database for Share Point 2007-2013 and Create user accounts for internal and external (Foreign) partner Sites and troubleshoot problems
• Routine management and troubleshooting of three pre-existing SharePoint farms.
• Create documentation and diagrams of the existing SharePoint farms.
• Managed and create Active directory account for all users and upload PKI certificate and troubleshoot related issue
• Serve as Tier 3 service desk escalation support to customers and application owners through Remedy
• Increase day-to-day operational efficiency and accuracy via the use of automated tools and scripts
• Install, administer and maintain virtual environments and physical hosts.
• Utilize manual checks, GUI-based, and command line tools (PowerShell) to troubleshoot and remediate basic to complex systems hardware, software, and configuration issues on assigned systems, networks, Active Directory.
• Participate in or lead special projects and day to day operations as needed or assigned by the site lead, and clearly communicate technical information to both technical and non-technical personnel.
• Administer, distribute, update software, deploy operating systems, apply patches
• Responsible for the administration, troubleshooting and maintenance of Unix/Linux servers and over 30+ Windows Servers in an external Active Directory Windows 7 and windows 2012R2 environment to include Exchange, File Server, DHCP, Retina, Print, SCCM, WSUS, SQL, SMS, SharePoint and VMWare
• Use Remedy ticketing system to provide tier-3 resolution until completed

Environment: SharePoint 2007-2013, SQL Server 2012/2008R2/2008 and 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), ASP.net Applications, VISIO 2010, IIs Application Server Windows Server 2012R2, 2008R2, 2003, AD (Active Directory) . Third party Application.

Confidential

MS SQL DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008 R2, & 2005 in Development, Test and Production Servers
• Patch Management: Applied SP (Service Pack) and HOT Fixes on SQL Server Database Servers
• Database Upgraded: Upgraded from SQL Server 2005 to 2008 R2 side by side method
• Installed and Configured SQL Server Reporting Services (SSRS) in 2008 R2 and 2012
• Database Monitoring: Monitored Database Servers, Databases, Agent, Jobs log files
• Backup/Recovery: Setup jobs and troubleshoot jobs related to backup, Recovered Database in Point-In-Time
• Used DBCC and DMV for different purposes
• Created, Modified, and Managed Indexes (Clustered/Non-Clustered, Simple, Composite), Constraints
• Performance Tuning: Worked on performance tuning to improve performance for different applications, SQL/TSQL code using different Performance tools such as Query Execution plan, Database Tuning Advisor, Profiler.
• Database High Availability: Configured and Managed Database Mirroring, Log Shipping, Replications,
• Data Modeling: Worked on Data modeling projects for new system and reddening existing system, have used different data modeling tools ERWin, VISIO, and Toad Data Modeling, well versed with Backward & Forward Engineering for data modeling
• Database Programming: Wrote T-SQL, and Stored-Procedures for reports, and applications
• DTS/SSIS: Excellent in loading data, data conversion from Flat file, CSV file, Excel and from other Data Sources like Oracle, MySQL, and Access to SQL Server, Setup Jobs using SSIS package, Moved and Migrated DTS Packages to SSIS package

Environment: Windows server 2008R2, 2003R2 SQL Server 2008R2/ 2008/ 2005

Confidential

MS SQL DBA

Responsibilities:

• Installed, configured, and Managed SQL Server 2008R2 and 2005 database instances in development, test and production environment.
• Performed Backup and Recovery, Designed backup strategies for Development, Test, and Production and Mission Critical Systems including Point-in-Time Recovery, automation and test procedures
• Upgraded and Migrated databases from SQL server 2005 to 2008R2 Managing and maintaining High availability technologies: Log shipping and Mirroring
• Applied SP (service Pack) and Hot fixes on SQL server database instance
• Data Modeling: Worked on multiple Data Modeling projects including designing a database from scratch, crating tables, views, indexes, constraints, business rules, creating scripts, E-R Diagram, backward/forward engineering
• ETL: Designed, Implemented, and Managed ETL Projects using SSIS, and DTS, Migrated and Upgraded DTS packages to SSIS packages, Processed data from Flat file, CSV file, and Excel file using Export & Import utility, Performed Data dump from Oracle, and My-SQL databases to SQL Server Database using SSIS, and EXP/IMP tool
• ETL: Designed, Implemented, and Managed ETL Projects using SSIS, and DTS, Migrated and Upgraded DTS packages to SSIS packages, Processed data from Flat file, CSV file, and Excel file using Export & Import utility
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed, Deployed, and Managed Reports
• Managed Reports Security
• Tools Used: Developed Reports using BIDS (Business Development Studio), Report Builder 3.0, 2.0, and Data Tools
• Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities
• Migrated Reports and Reporting Servers