SUMMARY

• An experienced SQL Server DBA with detail oriented, analytical and troubleshooting having more than 10 years of professional experience in different Microsoft products as a SQL Server DBA.
• 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, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc.
• Strong Experience on AlwaysOn High Availability and Mirroring. Working experience entails strong knowledge on using database third party tools like Idera, SpotLite, ERWin, Visio, and Toad Data Modeler.
• Working experience also includes working Azure Services, IaaS, PaaS, Migrating on premises databases and Legacy products on Azure, Build and deployment products on Azure, Setup development and test environment on Azure.
• 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

• Database: SQL Server 2016/2014/2012/2008 R2/2005/2000, MS Access 2007 & 2003 Oracle 11g R2 & 12c, MySQL 5.5.6, 5.1.23
• Operating System: Windows Server 2012/2008 R2/2003, UNIX/Linux, VMware
• Languages: SQL, T - SQL, PL/SQL, HTML, DHTML, XML JavaScript, ASP, ASP.net and C++
• ETL Tools: SSIS/DTS, BCP
• Reporting: SSRS (SQL Server Reporting Services)
• Data Modeling: ERWin, Visio, Toad Data Modeler, SSDD (SQL Server Database Diagram)
• Third-Party Tools: SolarWinds, Idera, SpotLite, ERWin, Visio, Toad Data Modeler, UltraBack, IBM Tivoli
• Networking: Active Directory, TCP/IP, DHCP/LAN/HTTP/ HTTPS
• Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C

SQL Server Database Administrator

Responsibilities:

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Manage and maintain production servers by checking stability and performance related issues Configured and Maintained C*CURE 9000
• Maintain production environment including monitoring of system health and performance to ensure high level of performance.
• Implementing Cyber Security by searching comprehensive file details including file hash, owner, path, size, and category alongside device information such as hostname and IP address.
• Wrote T-SQL scripts for different applications like CCURE 9000, MAS, and SAS and worked together with developers.
• Made documentation for SQL Database Backup strategy, maintenance plan, Azure database setup and retention policy
• Installed and Configured Business Intelligence Reporting Services (BIRS) and administering Reports and Reporting Server.
• Created, enhanced, maintained essential BIRS Report for Operations and End users.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Setup VMware in datacenter cloud system, Configured an ODBC data source to connect to the MS SQL Server Database
• Upgraded/Migrated SQL Server 2005 and2008 instances and databases to MS SQL Server 2012/2014/2016
• Started the Progress client and connect to the Progress database that needs to be migrated and converted progress database source code to MS SQL database.
• Performed data migration enforcement tasks, cleansing enrichment and mapping tasks with management and technical services personnel.
• Installed, Configured, and Maintained SQL Server 2008, 2012, 2014 & 2016 in development, test, and production environment.
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes
• Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application.
• Design, development, automation, and maintenance of inbound and outbound data transformation solution.
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.

Confidential, Herndon, VA

SQL Server Database Administrator

Responsibilities:

• Working experience on Disaster Recovery, Backup, Restore and Point in Time Recovery to ensure 24/7 application services
• Configured, Manage and Maintained Fail-Over Clustering using SQL Server instances to provide disaster recovery solution
• Configured and Maintained Replications, Log Shipping, Mirroring, AlwaysOn for High Availability solutions
• Installed and Configured SQL Server Reporting Services (SSRS) for Managed Reports development, deployment, distribution and reports subscriptions
• Developed, deployed, and managed Reports in SSRS using multiple sources like SQL Server, Oracle, and MySQL.
• Migrated Oracle 10gR2 and 11gR2 and MySQL 5.1.23/5.5.6 databases to SQL Server 2012
• Alerts on changes or leaks to help ensure data integrity, monitoring and real time security policies protect data across the enterprise
• Encrypt and Mask Data for data security and prevent form vulnerability
• Performed performance tuning for databases, servers and optimization of SQL/TSQL queries
• Strong TSQL experience like creating, modifying tables, Index, Constraints, Views, Stored Procedures, Triggers, scripts for application and reports.
• Deployed database design through Backward & Forward Engineering with data modeling tools for schema design, entities, relationship, constraints, developed E-R Diagram using ERWin
• Data Dump/Export/Import of data from/to Flat file/CSV file/Excel to/from SQL Server Database using DTS, SSIS, and SQL/TSQL
• Scheduled, managed, troubleshooter of jobs related to backups, monitoring database health, disk space, backup verification, cleaning history, log shipping, replication
• Monitor Server Activity, Error Log, space usage and solving problem by using Solar Winds
• Managed MySQL Server instances and Databases using Workbench, SQL Front, SQL Open, MySQL PHP Admin
• Applied SP (Service Pack) on SQL Server 2012, 2008 R2 on a routine basis

Confidential

SQL Server DBA/Administrator

Responsibilities:

• Migrated and Upgraded from SQL Server 2005 to 2008 & 2012, providing digester recovery plan and high availability solutions
• Installed and Configured database software, and other associated database tools
• Worked on database design using Toad Data Modeler and also worked closely with clients for information gathering
• Performed UAT to verify that database changes perform without adverse consequences.
• Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
• 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 & Active/Active), Multi Node Cluster up to 8 Node.
• 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.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database 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, Bohemia, New York

SQL Server DBA

Responsibilities:

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