SUMMARY:

• 6+ years experienced in Data Modeling, Relational Database Architecture and Implementation, Systems Architecture and Development, Database Administration and implementation of Administration Standards. Over the years I have been involved in large number of project development, managed large number of Projects.
• Experienced to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
• Experienced in the Agile software development process including working with the business to prioritize requirements into logical and manageable groups for rapid intake into the Agile development process, based on development resource capacity.
• Expert level of experienced to develop database solutions by designing proposed systems, defining database physical structure and functional capabilities, security, back - up, and recovery modes.
• Experienced in determining database structural requirements by analyzing use-cases and performance objectives, including high availability using high availability solutions like Clustering, Database Mirroring, Log Shipping, and Replication of databases for large, medium and small customers to further increase scalability and stability of business-critical systems.
• Experienced in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Experienced in data center migration from existing databases to remote data centers.
• Intensively experienced in monitoring/tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experienced in managing databases on multiple disks using Disk Mirroring and RAID technology.
• Experienced in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP).
• Experience with Reporting Services (SSRS) and Analysis Services (SSAS).
• Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation from previous versions.
• Experienced in creating maintenance plans to perform index defragmentation, re-indexing and update Statistics.
• Proficient in troubleshooting database issues.
• Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
• Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications.
• Team player with Good communication, interpersonal and business analysis skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008 , Oracle 9i/10g, MS Access, MySQL

Database Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio, SQL Server Data Tools(SSDT), Microsoft Team Foundation Services

Development skills: T-SQL,PL/SQL,SSIS/SSRS/SSAS

Languages: T-SQL, PL/SQL, HTML, XML, Power Shell

ETL Tools: DTS, SSIS (SQL Server Integration Services)

Reporting Packages: SQL Server Reporting Services (SSRS), MS Excel

Operating Systems: Windows Server 2008/2012/2016 , UNIX (Solaris, RedHat)

Tools: /Methodologies: MS Project, SQL Profiler, and Oracle

Monitoring Tools: Microsoft System Center Operation Manager (SCOM), Perfmon, SQL Activity Monitor, SQL Fragmentation Analyzer

PROFESSIONAL EXPERIENCE:

Confidential, Morristown, NJ

Sr. Database Administrator

Responsibilities:

• Responsible of designing and architecting Microsoft SQLAlwaysOn infrastructure in both UAT and PORD environment and migrate 10 standalone database infrastructure to SQLAlwaysOn platform.
• Responsible for managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Responsible for configuring and managing on premise and cloud based servers and maintain database servers and processes, including designing and implementing Database High Availability (HA) and Disaster Recovery (DR) infrastructure in multiple data centers.
• Responsible for installing and maintaining SQL Server database systems. Maintaining the database systems includes successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for providing database administration in terms of performance, maintenance, synchronization, security, and accessibility of production Microsoft SQL Server database systems with demonstrated proficiency in database replication, backup and restore, performance tuning and scalability. These enterprise database systems support Microsoft SharePoint Portal Services, Microsoft System Center.
• Responsible to set up maintenance plans for proactively monitoring the performance of all SQL Server databases including monitoring failed and long running MS SQL Server jobs. Monitor, tune and analyze database performance and allocate server resources to achieve optimum database performance using Fog Light application.
• Responsible for large scale database migrations from SQL server 2005 to SQL server 2008 R2 and 2012.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Resolved post-migration dependency issues of databases using SSIS packages.
• Monitored the health and performance of SQL OS, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintained Log Shipping between various environments.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
• Backed up master & system databases and restoring them when necessary.
• Optimized the Indexes, adding/deleting them when necessary for better performance.
• Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Involved in improving database performance using Extended Events, SQL Profiler, Trace Flags, Execution plan and DTA and third party tools.
• Worked with installation, configuration and creation of SSRS.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Environment: Windows server 2008/2012/2016 , UNIX ( Solaris, RedHat), MS SQL Server 2014/2012/2008 , Oracle 9i/10g, MS Access, MySQL, T-SQL, PL/SQL, HTML, XML, ALM, UFT, Java, Jira, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio, SQL Server Data Tools (SSDT), Microsoft Team Foundation Services T-SQL, Team Foundation Server, MS Excel, MS Project, SQL Profiler, Microsoft System Center Operation Manager (SCOM), Perfmon, SQL Activity Monitor, SQL Fragmentation Analyzer.

Confidential, Chicago, IL

Database Administrator

Responsibilities:

• Involved in database migration from SQL 2008R2 to SQL 2012.
• Created and managed schema objects such as tables, views, indexes, procedures and triggers.
• Performed database backups, restored database from backup.
• Analyzed and determined informational needs & elements, data relationships, proposed manipulation, data flow, and storage.
• Defined logical attributes, design/data structures to accommodate database production, storage, maintenance, and accessibility.
• Performed server installation and configurations for SQL Server 2008R2 and SQL Server 2012
• Setup Backup and Restoration jobs for Development and QA environments.
• Installed, configured, migrated, maintained and managed SQL Server 2005 & 2008 in development, test, and production environment.
• Took full responsibility for SQL 2008 cluster design, installation and configuration.
• Provided installation and maintenance support on operating systems.
• Planed, designed and scheduled Database Maintenance & Administrative Tasks on a daily and weekly basis and followed up and troubleshoot problems.
• Developed ETL packages to integrate multiple data streams.
• Responsible for backup, restore and recovery process of the SQL 2008R2 servers.

Environment: MS SQL Server 2008r2/2012, VB Script, UNIX, Web Logic, Oracle, HTML, XML, Windows 2008/2012 server.

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Configured relevant SQL Server components including database backup, consistency, integrity and network utilities to ensure health and access of each database.
• Resolved the day to day maintenance tasks.
• Applied service packs on SQL Server 2008.
• Worked extensively with SSIS in SQL Server 2008 to automate DBA tasks.
• Worked extensively with backup and restore requests.
• Responded and resolved database access and performance issues to meet business SLA's.
• Monitored database system details within the database, including the stored procedures and execution times and implemented efficiency improvements. Also able to perform a database transaction and security audit.
• Supported redundant systems for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Created a mirrored database on the report server using database mirroring.
• Ability to quickly troubleshoot and conduct root cause analysis.
• Ownership and accountability for production level issues.
• 24X7 PRODUCTIONS, USER SUPPORT & ON LINE SUPPORT.

Environment: MS SQL Server 2005/2008 r2, Enterprise Manager, Query Analyzer, and System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, T-SQL, Third party Application, Windows 2003/2008 server etc.