SUMMARY

• 8 years of experience as SQL Server DBA (2014, 2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP), NETIQ,EMS.
• Extensive hands - on experience with MSSQL Server upgrades/migrations and VMWare environments.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms includingServer Data Tools (SSDT BI), BIDS (SSIS &SSRS), and Master Data Services in SQL Server.
• Hands on experience in designing stored procedures, triggers, functions, views using Transact SQL (T-SQL) Programming.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Requested refreshes pre or post restore activities.
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Transactional & Merge Replication in SQL Server 2008/2005.
• Involved in Migrating MYSQL to SQL Server 2008 databases.
• Experience in installing and configuring SQL Server 2014/2012/2008 R2/2008/2005/2000 SQL Server versions.
• Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Well versed in using several tools for project management, system & database architecture and Management Process developments.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive).
• Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.
• Extensively used third party tools like Lite Speed, Fog light and Red gate.
• Used Erwin modeling tool for designing database objects.
• Development of Automated notification when SQL Server Backups and schedule maintained jobs.
• Experienced in planning for and recovering environments in the event of disasters.
• Experienced in SQL Server Integration Services (SSIS).
• Experienced inSQLServer Reporting Services (SSRS) such as, building tabular report, matrix reports using report designer/report builder.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Forecast and plan capacity requirements and future growth needs of specified applications and supporting infrastructure components.
• Understand technical infrastructure and recommend solutions consistent with the environment, technical knowledge, resources, availability requirements, etc.
• Testing methodologies and tools - Automation and Performance testing.
• Expertise in integration of data from diverse data sources like Oracle, Excel, MS Access, and DB2 to MS SQL Server by using Import Export Wizard, DTS, and SSIS.
• Designed and Created Customers, Profile Classes & Bank information and General Ledger Accounts using Oracle General Ledger.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in data modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Experienced in using Data Modeling Tools like Erwin, MS access and Microsoft Visio
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• Testing methodologies and tools - Automation and Performance testing.
• 24/7 Production Databases on Call Support. Excellent Analytical, problem solving and communication skills.
• Clear understanding of Windows Server Events and SQLServer Events.
• Interfaced with database vendors & client technical support teams to isolate & resolve database related problems.
• Strong conceptual, analytical, and design skills with leadership qualities and hard working with a mission and having passion to learn new technologies.

TECHNICAL SKILL SET:

Languages: C, C++, C#, .NET, T-SQL, VB script 6.0, HTML, XML, Active Scripting.

RDBMS: MS SQL Server 2008, 2005, 7.0, MS-Access, Mongo DB.

Front End: MS Visual Basics 6.0

Web Technologies: HTML, XML and Java Script

Middle Tier: MSMQ, Web Logic, Web Connect, Microsoft .Net Technology

Reporting Tools: Crystal Reports, SQL Server Reporting services (2000, 2005,2008,2012 and 2014)

Web Server Technologies: IIS 5.1/6.0

Data Modeling Tool: ERWIN 4.0, Visio 2002

Operating System: Windows 2012 Advanced Server, Windows 2012 data center, Windows NT, Win XP Prof/Standard

Other Tools: Idera Diagnostic Manager, Quest spotlight, Fog light, VMware, OLAP, OLTP.

Hardware: EMC DMX & IBM Fast T 700 Storage Area Network (SAN), Compaq ProLiant 8000, 6500, 6000

Scripting+Dev: PowerShell, NETIQ

PROFESSIONAL EXPERIENCE

Confidential - Scranton, PA

Sr SQL Server DBA

Responsibilities:

• Migration of databases from SQL Server 2005 to SQL Server 2008R2 and SQL Server 2012.
• Installed SQL Server 2012 and configured Always on With Primary and secondary Replicas, Read only databases, listener and with Application Intent.
• Importing data into SQL from SQL Servers
• Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Performed horizontal data partitioning for efficient management of database tables and indexes.
• Working on Client/Server tools like SSMS, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
• Developing T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Worked on NETIQ in creating databases and EMS to manage the databases
• Experience in writing scripts like retention of data using batch deletes.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Incremental loading of dimensions, facts, error handling in SSIS.
• Created Dynamic SSIS packages, to load Stage tables from text files.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• In order to Export a data from SQL to Csv file we use PowerShell export csv cmdlet which is an alternative methodology for SSIS
• By using Microsoft azure using PowerShell 2015 we generating query results from SQL server
• Microsoft Azure is used as a backup in order to generating PowerShell scripting to avoid errors and also used to generate SSRS
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Microsoft Azure is used to Migrate to SQL 2014 on cloud by using SQL server
• Azure is used in upgrading the production databases servers
• Within SSMS and export it to CSV if there any modification we use PowerShell
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Configured and managed virtual Servers and worked on virtualization and clustering environment.
• Worked on NETIQ in writing scripts about creating databases and worked on production databases
• Worked on EMS in managing and creating databases and provide security encryption

Environment: Server 2012/2014(2003, 64 bit edition of SQL Server 2012), 7.0, Crystal Reports, SSAS, SSRS, SSIS, VBScript, XHTML, XML, AdobeCQ, Windows 2003 Advanced Server, IIS 5.0, 6.0, 7.0, PowerShell 2007, Microsoft Azure Using PowerShell 2015

Confidential - Herndon, VA

Sr SQL Server DBA/Developer

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshot issues with the same. Applied hot fixes and Service Packs in clustering environments.
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2012, 2008r2, 2005.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshot issues with witness servers.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• Experience in Configuring, Managing and troubleshooting on SQL Server connection protocols like Kerberos and NTLM.
• Expertise in registering a SPN for Kerberos Connection and Performing NTML Failback.
• Implemented Kerberos Delegation with SSRS.
• Expertise in Fixed several Common issues in Kerberos and NTLM protocol like "Login Failed for user", "Could not open a connection to SQL Server", "Cannot generate SSPI Context", etc.
• Involved in migration of SQL 2005 TO SQL 2008r2
• Performed daily backups and developed recovery procedures
• Implemented databases for stored procedures based on NETIQ as well as EMS in order to manage the databases
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Scheduled and monitored all maintenance activities ofSQL Server 2005 including database consistency check, and index defragmentation.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Set up database backup and recovery strategies.
• Worked with development teams in the design and modification of physical databases.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Implemented partitioning to handle tables with over 300 million rows.
• Implemented database mirroring for constant availability of sales force automation and product routing.

Environment: MS SQL Server 2005, Enterprise Manager, Management Studio, Integration Services, Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services 2008, C#, ASP.NET,VB.NET, OLAP, Microsoft Azure Using PowerShell 2015, PowerShell 2007

Confidential - Austin, TX

SQL Server DBA/Developer

Responsibilities:

• Monitoring and TroubleshootingSQL Server Performance using Query Tuning,SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Working on production Break fix issues which include performance, blocking and space related issues.
• Providing 16/7 support for critical production databases of Confidential Datacenters.
• InstalledSQL Server 2008, 2012 on hundreds of machines/clusters.
• Worked on Projects to provideDBA support for BuildingSQL Servers for new applications (begin to end support).
• Scheduling Jobs and Alerts using DB Mail.
• Using Fog light to monitor/Test theSQL Server Databases alerts.
• Implemented table and index partitioning.
• Database Migrations fromSQL2005 to 2008 &2012.
• Configuring SSRS, Deploying and Migrating SSRS reports.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Maintaining USER PERMISSIONS, LOGINS and SECURITY Issues. Monitoring Event Viewers, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Monitoring servers thru Fog light alerts.
• Installing drivers for DB2, Teradata, Oracle, MySQL for Configuring linked servers and Data migration as per line of business requirement.
• Database refreshes on Lower environments.
• Working with Maximo Change Request(Any changes in Production database need to Create Maximo Tickets this should be approved by Global DBA team after changes made in stage and development environment)
• Creating and scheduling maintenance routines.
• Configuring CLUSTERING, LOG-SHIPPING, MIRRORING, REPLICATION(Transactional, Peer to peer, Snapshot)
• Resolving all high availability Issues.
• Working with development teams to resolve ETL packages errors and deployments
• Create and Modify of the database objects according to the requirement.
• Resolving Database Failures, Physical Server Failures and SQL Server Service Failures
• Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards at Bank.
• Implemented backup and Recovery strategies.
• Release activities including Spec reviews.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.

Environment: SQL Server 2000/2005/2008/2012 with Clustering, MS Access, VMware ESX, Fog light, Windows 2012/2003, Lite speed 5.0, TSM, DTS, RML Utility, T-SQL, C#, VB.Net ASP.Net 4.0, Visual Studi 2008, SSIS, SSAS and SSRS, PowerShell 2007, Microsoft Azure Using PowerShell 2013

Confidential

SQL Database Engineer

Responsibilities:

• Assisted DBA in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.
• Experienced in creating/modifying Tables, Views, Stored Procedures, Functions and Triggers along with in- depth knowledge in query optimization & performance tuning.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/ DTS packages.
• Developed the packages with monitoring features and logging for audit information of the packages.
• Extensively involved in partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Involved in database design and development using stored procedures, triggers, views and few cursors.
• Involved in initial requirement gathering for BI part of the project.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Developed multiple SSRS reports for the project and written the part of .Net code to display these reports using ASP.Net report viewer.
• Data flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing and new packages.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008.
• Created several complex SSIS packages. Custom components were written in VB.Net.
• Used SQL Server Agent for scheduling jobs and alerts.
• Created subscriptions to provide a daily basis reports.
• Migrated SAP Crystal reports to SSRS reports.
• Involved in migration projects from Teradata to SQL server.
• Created Cursors to facilitate the users to scroll through the Queues to perform manual operations on the payment.
• Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database table. Designed XML documents and generated XML documents from tables.
• Automated many operations by scheduling multiple DTS packages using jobs.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard.
• Implemented web based front end using ASP.NET, JQuery, CSS, HTML controls and business logic using C#.
• Performed daily tasks including backup and restore data by using SSMS tools like SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.

Environment: SQL Server 2005/2008, ASP.Net 3.5, C#, VB.Net, Team Foundation Server (TFS), T-SQL, SQL Server Management Studio 2005/2008, SQL Server Profiler, SQL Server Agent

Confidential

SQL Server Database Developer

Responsibilities:

• Involved in the study of existing system.
• Designed and developed the database from scratch, created clustered indexes, created and optimized the stored procedures and triggers and constraints.
• Created ASP.NET web pages that provide new features and enhanced user experience.
• Used C#.NET to write server-side code for the user interfaces.
• Developed the web pages using Visual Studio, HTML, and CSS for styling the Web pages.
• Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written t-SQL procedures for transactions, created indexes for performance tuning.
• Responsible for understanding the customer requirements and database administration.
• Participated in meetings with the client and team members.
• Developed triggers and stored procedures to incorporate the business logic and process.
• Using the data transformation tasks like BCP, bulk inserts to import/export data.
• Created users, roles and giving appropriate permissions to the members as part of the security implementation. Scheduled the jobs to run on monthly basis.
• Used validation techniques and java script for user input validation.
• Supported front-end development team to resolve SQL related issues in active server pages design and develop user control for the application.
• Major role in documentation and maintenance.
• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

Environment: SQL Server 2005/2008, ASP.Net, C#, VB.Net, VSS (Visual Source Safe), MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio.