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 R 2/2008/2005/2000 , ORACLE, MS Access, MySQL

Database Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),Power BI Desktop, SQL Server Reporting Services (SSRS), Business Intelligence & Development Studio and Erwin

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

Languages: T: SQL, HTML, XML, Power Shell

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

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

Operating Systems: Windows Server 2008/2012/2016 , IBM AIX /Solaris UNIX.

PROFESSIONAL EXPERIENCE:

Confidential - Chevy Chase, MD

SQL Server DBA

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 2008/2012 Server, SQL Server 2008/2014, MS Office, Power Shell, Java, Jira, XML, HTML, SSIS, SSRS, SSAS, Power BI Desktop, SQL Server Data Tools, T-SQL, Team Foundation Server, ASP.NET.

Confidential - Seattle, WA

MS SQL DBA

Responsibilities:

• Performed business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Involved in Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferred the data (ETL) to Data warehouse (Informatica) by SSIS.
• Worked extensively on Dynamic Management Views in SQL Server 2008.
• Installed, authored, and managed reports using SQL Server Reporting Services.
• Managed the migration of SQL Server 2008 databases to SQL Server 2012.
• Monitored SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Worked extensively on Data Partitioning and Snapshot Isolation.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Rebuilt the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in rebuilding the indexes at regular intervals for better performance.
• Managed the VERITAS net backups.
• Worked extensively on DBCC commands and Dynamic Management Objects.
• Involved in the trouble shooting and fine-tuning of databases for its performance and concurrency.
• Completed documentation on the database. Recovered databases from backup in disasters.
• Exported or imported data from other data sources like flat files using Import/Export through DTS, SSIS.
• Analyzed long running slow queries and tuning the same to optimize application and system performance.
• Set up SQL Server configuration settings for better server management.
• Monitored the servers using Idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Confidential - Dearborn, Michigan

SQL DBA

Responsibilities:

• Worked with the project team, and 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.
• 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.
• 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.