SUMMARY:

• I have extensive experience 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 & been a DBA with large number of Database Servers.
• 6+ years of experienced to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
• 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 database mirroring or SQL AlwaysOn availability group and replication strategies.
• Hands-on experience in SQL Server implementation, maintenance, administration and 24x7 support in multi data center environments that includes development, UAT and Productions infrastructure .
• Experienced in Performance Tuning, Backup and Recovery, Query Optimization and Security.
• Experienced in Upgrade/Migration of MS SQL Server 2005/2008 to MS SQL Server 2008R2, 2012 and 2014.
• Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third party solutions.
• Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.
• Experienced in developing, troubleshooting SSIS (ETL) DTS packages using best practice methodologies and in a manner consistent with existing database design objectives.
• Created various SSRS and SSAS Packages to serve company needs.
• Expert in using DTA/Extended Events/PerfMon/SQL Profiler/Scripts and other third party tools to resolve bottlenecks, dead locks and slow running queries.
• Responsible for securing SQL Server, user management, assigning permissions and roles.
• Experienced in VMware virtualization, Hardware/Software Clustering, RAID and SAN/NAS technology.
• Strong System Administration background in Windows and Linux environments.
• Experienced in working independently as well as in team-oriented environments.
• Expert in problem solving, analysis and conflict resolutions.
• Experienced in supporting and maintaining large databases and troubleshooting their problems.
• Excellent analytical, communication and interpersonal skills.
• Basic Knowledge on Oracle databases.

TECHNICAL SKILLS:

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

Programming: C, C++, JAVA, HTML, Shell Script

Operating System: Windows Server 2003/2008/2012 , IBM AIX, Unix, Oracle Solaris 10

Monitoring Software: HP Sitescope, Microsoft SCOM, Red Gate, Precise

Tools: TOAD, Visio, ARIN

Network Topologies: TCP/IP, DNS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

• Responsible for installing, configuring, and maintaining Microsoft SQL Server 2012 AlwaysOn Availability Groups and Failover clusters.
• 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 installing and configuring MS SQL Server 2005, 2008, 2008R2 and 2012 on Windows 2003, 2008, 2008R2 and 2012 and applying service packs and security fixes on these MS SQL Servers.
• Responsible for large scale database migrations from SQL server 2005 to SQL server 2008 R2 and 2012.
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• 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: SQL Server 2012/2008, Windows Enterprise Server 2008/2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services.

Confidential, Silver Spring, MD

SQL DBA

Responsibilities:

• Defined data, information and underlying technology roadmap.
• Developed enterprise-level conceptual, logical and physical data models.
• Established data / database architecture guiding principles and design goals.
• Facilitated and reviewed enterprise wide data dictionaries.
• Worked with performance tuning monitors to identify performance issues.
• Optimized indexes and foreign key relationships.
• Optimized stored procedures and triggers.
• Optimized scalar functions and knowing when such functions impact performance.
• Used SQL Server Snapshots.
• Worked closely with the other Application Groups and other domain experts.
• Established information models, data flows and data life-cycles throughout the enterprise architecture.
• Analyzed and specified standards based data exchange with 3rd parties.
• Identified data integration opportunities.
• Evaluated, recommended and selected database tools & utilities.
• Established formal policies and procedures for data model review and approval.
• Identified and implemented best practices, tools and standards (ER modeling, normalization, data security, etc.)
• Facilitated, monitored and resolved database performance, scale and availability activities.

Environment: SQL Server 2012/2008 R2, Oracle, .Net Framework, C#.Net, Asp.Net, JavaScript, VSS, Windows 2008 Server.

Confidential, Mt Laurel, NJ

SQL DBA and BI Developer

Responsibilities:

• Installed and configured SQL Server 2008/2008R2 in test environment with latest service packs and installed few databases.
• Attached the copy of the databases in the SQL Server Management Studio and execute the scripts.
• Involved in carrying out successful Microsoft SQL Server performance optimizations to provide a quality customer experience.
• Worked with the project team, with the application domain experts to establish achievable deliverables from requirements provided.
• Worked with the project team to identify/clarify project goals, establish useful milestones, and developed a breakdown of the engineering tasks to be performed.
• Performed Database analysis, design and troubleshooting.
• Optimized the Views, Queries and Stored Procedures to enhance the Reports Performance. Created indexes wherever possible to speed up the queries which in turn enhance the performance of the Reports.
• Created the new ODBC connection for viewing and connecting the Crystal Reports X1 to the newer databases.
• Created new SSRS Reports in Visual Studio 2008 with enhanced layout and modifications.
• Used Import /Export Wizard to transfer the data from Excel file to table.
• Developed Sub Reports, Matrix Reports and Tabular, Charts, Drill down, Drill through and Parameterized reports using SQL Server Reporting Services (SSRS).
• Successfully deployed the reports on the Report Manager.
• Optimized the Reports performance by checking the Execution Plan and SQL Server Profiler.
• Used Query optimization techniques wherever possible to enhance the reports performance.
• Wrote stored procedures and functions to simplify the logics in the Reporting services. Added parameters in the reports to filter data effectively.

Environment: SQL Server 2008 r2, Windows 2008 Server, SQL LiteSpeed, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.