OBJECTIVE:

To continuously contribute in a fast paced, dynamic environment in the field of Database administration, SQL server on Azure, SQL server on Linux, SQL Database Development, BI development that would enable me to utilize my technical / analytical skills, excellent inter - personal skills and strong work ethics.

PROFESSIONAL SUMMARY:

• 6 + years of MS SQL Server experience in multiple domains: Finance, Technology, Mortgage and Insurance domains as assigned role of DBA, Confidential product support Engineer, Business analyst, Data Analyst, BI/ SQL developer.
• Expert in installation, configuration and maintenance of MS SQL Server 2016| 2014| 2012| 2008 R2|2008|2005 in standalone and clustered servers
• Strong experience in reviewing, planning, testing, and installing security patches, hot fixes, cumulative updates, and service packs.
• Implemented SQL Server security, controlling permissions and monitoring audit events
• Extensive experience in comprehensive backup plan and disaster recovery strategies
• Hands-on experience with high availability and disaster recovery solutions such as SQL Server Failover clustering, Always On availability, Replication, Mirroring, Log shipping
• Experience in creating, modifying and managing databases, schemas, tables, stored procedures, functions, triggers, views, indexes and constraints
• Extensive experience in data migration between multiple environments with SSIS packages, backup/restore, detach/attach, import/export wizard & Optimizing ETL Process
• Highly experienced in Database Maintenance Plans, scheduling of Jobs, Alerts and notifications using Database Mail.
• Strong experience in using Execution plans, Extended Events, SQL profiler and Database Engine Tuning Advisor to optimize queries and enhance performance of databases
• Solid experience in troubleshooting and performance tuning by using activity monitor, performance monitor, DBCC, DMVs, DMFs and third party tools such as Spotlight, Redgate, Idera monitoring,
• Advanced troubleshooting skills using Confidential PSSdiag, Nexus, SDP log collection, corruption analysis, cluster log analysis, set up bootstrap log analysis
• Experience with Policy Based Management, Resource Governor, and Transparent Data Encryption (TDE), active directory set up and addressing network related issues.
• Expert in defining Queries for generating drill down and drill through reports in SSRS.
• Expert in designing reports using Cascading parameters, Parameterized Reports, Report Models and ad-hoc re ports using SSRS.
• Experience in learning emerging technologies, SQL server on azure, SQL server on Linux
• Troubleshoot different SQL server component failures, analyzed logs and crash dumps
• Good experience in writing documentation and providing on-call support on a rotation basis
• Solid experience in Service Broker , Synonyms, SQL OS, SQL CLR , Windows Server OS, Networking.

TECHNICAL EXPERTISE:

Operating Systems: Windows server 2016| 2012 R2 |2008 R2| 2008| 2003, Windows 7| 8 |10 Linux operation system (Centos, Redhat), Ubuntu

Database servers: SQL Server, Oracle 11g, MySQL, Big data and NO SQL databases

Database Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler, SSIS, SSRS, DTS, BCP, Business Intelligence Studio (BIDS), SQL Server Data Tool (SSDT), PowerBI, Visual Studio

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

Languages: T-SQL, C#, XML, command prompt, & PowerShell

Other Tools / Software: MS Visio, Source Control, TFS, Windows System Monitor, Redgate, Litspeed, IDERA, ServiceNow, Remedy, MS Office Suite, Spotlight.

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, Texas

SQL Server Engine Support Engineer

Responsibilities:

• Supported Premier and Professional level customers on phone, via remote sessions and via written correspondences on issues related to SQL Server Engine/Performance/Setup etc.
• Scoped and documented various customer scenarios,, reproduced failures, derived action plans, conducted root cause analysis, and troubleshooting steps
• Used advanced troubleshooting techniques to resolve critical situation (CRITSIT) cases which had a major business impact to the customer
• Resolved SQL Server issues related to T-SQL programming, data integrity/corruption, backup/restore, setup/upgrade add/remove components, unresponsive servers, SQL Server administration tools, auditing, database maintenance plans, and exceptions
• Assisted in troubleshooting and deploying High Availability solutions such as Failover Cluster Instances, AlwaysOn Availability Groups, database mirroring, replication, and log shipping
• Provided a high level of technical support for SQL Engine/Performance (plan forcing and plan guides, indexing, evaluating query plans/tuning, ETL jobs), using performance tools (SQL Server Profiler, Nexus, SQLDiag, PerfMon, Database Engine Tuning Advisor), concurrency (locking), memory pressure, and SQL OS (SOS), deadlocks, blocking, Latch contention and timeouts
• Supported Service Broker, DTS, notification services, Full-Text Search, and In-Memory OLTP
• Supported Installation of Replication Server, Configuration and Monitoring the replication, implemented Transactional Replication, Merge and Snapshot, writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production.
• Provided best practice analysis in performance enhancements and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts.
• Helped set up and configured SQL server Certificates (SSL/TLS) using IIS, MMC for server and client authentication and supported TDE Encryptions
• Conducted numerous root cause analysis on unexpected failovers on HA & DR environment
• Configured multiple cases related to encryption from instance level to column level
• Helped customers all over the world deploy, configure, resolve multiple cases in high availability environment including log shipping, mirroring, cluster, and AlwaysOn issues ranging from set up, unexpected failures, transaction log ballooning, Maintenance job failures, failed synching, system database corruption, service account issues, performance degradation and upgrade failures.

Confidential, Washington, DC

SQL/BI Developer

Responsibilities:

• Performed Requirement gathering & analysis from the client side and developer team
• Documented Business & System Requirements Using IBM DOORS
• Organized enterprise metadata repository using Informatica Power point
• Data Standardization and rationalization to ensure enterprise naming convention
• Enforcing data Quality rules to upstream source using different tools
• Conducted UAT, regression and shakeout testing in the production environment
• Maintained Data consistency and database integrity.
• Performed numerous data extraction requests involving Oracle scripts
• Monitored business mail group for production impact assessment
• Conducted exception handling procedures in oracle database production environment
• Fixed the bugs present in already existing reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client's workstation.
• Created many multi valued parameters in the reports.
• Created many Cascaded parameters in the reports using MDX and T-SQL.
• Improved Report Performance and performed unit testing.
• Defined relationships between Measure groups and Dimensions.
• Implemented the calculations to aggregate physical measures.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.

Environment: MS SQL 2008R2 |, Windows Server 2008, SQL Server Management Studio, SQL Configuration Manager, SQL CMD, SQL Server Agent SQL Profiler, Performance Monitor, SSIS, Litspeed, MS Visio, Spotlight

Confidential, Springfield, VA

SQL Server DBA

Responsibilities:

• Ensured data recovery, maintenance, data integrity, and security of databases are met through formulation and monitoring of policies, procedures, and standards related to database management
• Installed, configured, and administered SQL Server failover clustering on SQL Server 2012
• Migrated databases from SQL Server 2005 to SQL Server 2008 R2 and 2012
• Applied compliance requirements within scope of responsibility, provided documentation as necessary and participated in compliance activities as required
• Conducted performance assessment and tuning for database systems by using profiler, extended events, performance monitor, activity monitor
• Utilized third party tool REDGATE’s SQL Monitor for SQL Server performance monitoring
• Inspected SQL Server logs and configured monitoring alerts for critical issues
• Implemented proper logins, roles and authentication modes as a part of security policies for various departments and type of users
• Monitored and modified database query performance using execution plans and index tuning
• Applied security patches and service packs to keep database servers at current patch level
• Deployed new code release to testing and production environments
• Designed and implemented table partitioning to improve performance
• Managing all aspects of database operations including implementation of database monitoring tools, event monitoring, and diagnostic analysis and performance optimization routines for resolving support issues.
• Designed, documented, and promoted security policies, standards, and protocols
• Implemented transparent data encryption (TDE) for certain databases based on business requirements
• Fixing Issues related to Orphaned Users and Managed Logins, Users, Roles and User permissions.
• Supported Development Team in deploying and testing the application, which uses SQL Server backend.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
• Designed and Implemented Disaster Recovery Procedures Log Shipping, Mirroring as well as Backup and Restore Strategies.
• Configured and managed database mirroring, log shipping, transactional and merge replication

Environment: MS SQL Server 2012, Windows 2008/2003 servers, Active Directory, ISA 2004, Outlook Express, IIS Web server, SQL Upgrade Advisor, MS Access, Confidential Analysis Services, Diagnostic Manager, Confidential Reporting Services, Autosys, Confidential SQL Server Integration Services(SSIS), Litespeed, UNIX OS and UNIX shell scripting

Confidential, Raleigh-Durham, NC

SQL Server DBA

Responsibilities:

• Created all task Migration Windows 2003 server to Windows 2008 server
• Successfully upgraded the databases from SQL Server 2005 to SQL Server 2008/2008r2.
• Managed security on Production and Development environments.
• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Created jobs to import/ export data obtained from various States to update different servers.
• Implemented and tested the point in time recovery of the production databases.
• Installed new SQL instances, applied service packs, performed in-place and side-by-side upgrades based on the Checklists
• Conducted Performance Tuning and Query Optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Established and maintained SQL Server database backup and recovery policy as per RPO and RTO
• Capacity planning & Benchmarking hardware, CPU, Memory, cache, Disk IO, RAID, Network, Virtual resources
• Designed and implemented table partitioning to improve performance
• Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
• Created and maintained clustered and non-clustered indexes; Rebuild and reorganized indexes; Found missing indexes and dropped unused indexes to increase performance.
• Designed stored procedures for module integrity and application and used multiple join statements to retrieve data from multiple tables.
• Created Backend validations using Insert/ Update and Delete triggers. Created views for generating reports.
• Responsible for migrating data using backup/restore, BCP utilities and SSIS packages.
• Developed and monitored SSIS packages on developer servers and deployed and validated them on production servers.
• Created Database, schema objects and granted permission to these objects based on database\server roles to users.
• Involved in designing of Conceptual Logical Model and Physical Model
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Configured product meta-data tables to support client data reporting needs.
• Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment.
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.

Environment: MS SQL Server 2008 R2 | 2005, SQL Profiler, Windows 2003, 2008, SSRS, SSIS, DTAETL, Query Analyzer, Business Intelligence Development Studio, Windows 2003/2008/2008 R2 Server, Visio, SQL Sentry, Tivoli Data Protection, Tivoli Monitoring, SQL Upgrade Advisor, SQL Profiler, Query Analyzer, Litespeed

Confidential, Laurel, Maryland

SQL Server DBA

Responsibilities:

• Responsible for Installing, Upgrading applying Service pack and Patches on SQL and windows 2008 R2/2008 in clustered & Stand-alone environments.
• Perform day to day duties such as database backups, restore, performance tuning, managing maintenance plans, monitoring scheduled jobs, checking database integrity, monitoring SQL Server logs
• Created user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Implement SQL Server dashboard reports, DMVs and Profiler to identify slow or hardware resource consuming T-SQL queries, enforced trace flags
• Identify unused indexes, create missing indexes and regular reorg/rebuild Index maintenance
• Assessing Database Locking Architect, Analyzing and Resolving Deadlocks, blocking, Latch contention and timeouts
• Deployed, configured, and administered Always On availability groups for high availability and disaster recovery
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Managed Capacity planning for the primary assigned servers to ensure adequate CPU, Disk space and Memory.
• Provide production support 24x7 on a rotation basis
• Document, and promote security "best practices", policies, standards and protocols.
• Participated in developing logical model and implementing requirements on SQL Server 2008R2.
• Created complex Stored Procedures, triggers, and Functions to support the front-end application.
• Successfully created schema change scripts to existing objects to synchronize with changing business rules.
• Monitored growth of database objects for capacity planning.
• Worked with Quality assurance to develop test plans and test cases to conduct system testing.
• Managed SharePoint server, SCCM, SCOM, Project server using SQL as a backend
• Involved in the development of Data warehouse and data migration
• Responsible for report generation using crystal reports based on business requirements.

Environment: MS SQL 2008R2 |, Windows Server 2008, SQL Server Management Studio, SQL Configuration Manager, SQL CMD, SQL Server Agent SQL Profiler, Performance Monitor, SSIS, Litspeed, MS Visio, Spotlight