SUMMARY

• Resourceful and result - oriented Microsoft CertifiedSQL Database Administratorwith morethan 7 years of hands-on work experiencein a big, fast-paced, high transactional production, development, staging and testing environment seeking SQL database administrator/developer jobwhere strongdatabase and related systems development, Administration, configuration and maintenance skillsare required.
• More than 7 years of successful IT experience, responsible on the day-to-day basis of database development and administration operations: designing, installing, upgrading,maintaining, monitoring, troubleshooting, tuning, backup, security, mirroring, log shipping,always-on, clustering and replication of SQL databases and routinely working on SSIS and SSRS services in the IT,Health and Financial domains.
• My Key technical Skills/Competencies on Microsoft SQL server versions of 2017,2016,2014,2012,2008r2,2008,2005and 2000 include:

TECHNICAL SKILLS

Operating Systems: Microsoft Windows (XP, Vista,7, 8), Ubuntu Linux, Windows Server 2008/R2 & 2012/R2…Networking TCP/IP, VPN, LAN/WAN, Firewalls, Switches, Routers, Wireshark programming languages T-SQL, PL/SQL,C, C++Version Control: Team Foundation Server (TFS), Visual SourceSafe (VSS).

Servers: MS Exchange 2010, Active Directory, DNS, DHCP, SQL 2008, SQL 2012, 2014 and 2016.

Programming Languages: Basic knowledge of C, C++, VB and Java HTML, Office Suites

Backup and Disaster Recovery Utilities: Idera, Symantec Backup Exec, Windows Server Backup

Security: Security Policies, Anti-malware/Anti-Virus (Trend Micro Security, Malware bytes), Barracuda Spam filters. Performance monitoring third party tool Red gateEnvironment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2005,2008,2008 R2,2012,2014,2016, IIS, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Studio 2010, Sybase, MYSQL, Toad, Indexes, Log Shipping, .Net Framework 3.5, snapshot, Replication, MS Office suite 2010.

PROFESSIONAL EXPERIENCE

Confidential

SQL Database administrator

Responsibilities:

• Database Development and Adminstration:
• Administered very large and complex databases inSQLServer 2005, 2008, 2008 R2, 2012, 2014 and SQL Server 2016 and Oracle including 24/7 Production support of the databases and round-the-clockdatabaseoperations.
• Managed databases spread across multiple servers in Production, Development, Staging and Testing environments usingSQL 2008, 2008r2, 2012, 2014 and 2016.
• Installed, Configured and upgraded SQL Server for cluster and standalone servers.
• Hands-on experience in installing, configuring and managing virtual machine VM Ware.
• Daily managed and administeredSQLserver security; creating Logins and Users with appropriate permissions, monitoring user accounts, creation of groups, granting the privileges to users and groups. Identified and Fixed Orphaned users through Stored Procedures.
• Expertise in database performance Monitoring, troubleshooting and Tuning - Troubleshooting using Performance Monitor, Activity Monitor,extended events,DMVs/DMFs,SQL logs,SQLProfiler and Third party Tools.
• Experienced in Index Maintenance, Index tuning, Rebuild and Reorganizing according to Index fragmentation, running DBCC checks and update Statistics to check Data Integrity.
• Extensive Experience in identifying and troubleshooting of Locking, Blocking and Deadlock issues.
• Implemented Policy Based Management, Resource Governor, performance data collector, and Transparent Data Encryption (TDE).
• Routinley Identified long running queries and tunned them. Generated XML plan for T-SQL performance. Resolved blocked and locked objects issues.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
• Conducted server and database auditing through the use of server side tracing, server audit specifications, and event notifications
• Strong experience in Database Backup, Backup compression, Restore and Disaster recovery procedures.
• Checked general health of the servers and the databases and Maintained large size production Databases.
• Scheduled and troubleshoot Alerts and Jobs and Monitored the status of Maintenance plans.
• Implemented high availability and disaster recovery solutions (Log Shipping, DB Mirroring, Clustering and Replication).
• Worked on Always ON Availability Group and creating listeners as per requirements.
• Migrated databases among the servers using BCP, attach/detach utilities, Bulk Insert, DTS and SSIS utility.
• Extensive experience onSQLServer Integration Services (SSIS) for data integration from heterogeneous data sources, ETL and DTS related operations.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions usingSQL Server Analysis Services.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Excellent knowledge and experience in writing complex T-SQL scripts, creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, and User defined data types, effective functions, Cursors and Indexes using T-SQL and database design, Normalization, De-normalization.
• Routinely Generated reports using SSRS.
• Performed installation, Configuration, and deployment of projects to SSIS, SSAS, and SSRS servers and produced reports using reporting server.
• Transformed data (Millions of records) toSQLServer using SSIS.
• Experienced on Power Shell, AWS, Microsoft Azure, Agile environments and Always-on availability group features in a clustered environment.
• Worked on RAID environment, mainly using RAID 0, RAID 1, RAID 5 and RAID 10.
• Excellent understanding of Microsoft System Center Operations Manager (SCOM), basic network configuration ofSQL, TCP/IP ports, DNS, SAN, LAN, WAN and Remote desk top access.
• Worked with end users to resolve their issues on all applications and provided 24x7 dedicated supports forSQL Server production servers.
• Advanced Oracle DBA experience with demonstrated experience in Real Application Clusters (RAC)
• Integration Services (SSIS):
• Proficient in usingSQLServer Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in design of ETL packages for integrating data from heterogeneous sources like (Excel, Oracle, Flat file, CSV) by using multiple transformations provided by SSIS.
• Proficient in usage of SSIS Control Flow items (For Each Loop, For Loop & Sequence container, execute package, executeSQL tasks, Script task, send mail task) and transformations (Conditional Split, Data Conversion lookup, Derived Column, Aggregate, Multicast).
• Hands on experience on ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in creating jobs,SQL Mail, Alerts and schedule SSIS Packages usingSQL Server Agent.
• Deployed SSIS packages to different environments.
• Analysis Services (SSAS):
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions usingSQL Server Analysis Services.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Experience in creating and managing SSAS Tabular models, creating Dimension Tables and Fact Tables.
• Reporting Services (SSRS):
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Supported team in resolvingSQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.
• Experience in usingSQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users inSQL Server Reporting Services (SSRS).

Confidential

SQL Database Administrator/Developer

Responsibilities:

• Managed day-to-day operations and troubleshooting of fast paced Health enterprise databases. This includes all aspects of database administration including installing, designing, maintenance, monitoring, tuning, backup security issues and upgrading of SQLdatabases.
• UpgradedSQLserver 2000 boxes toSQLserver 2005 and acted as the point of contact for all developers.
• UpgradedSQLserver 2005 toSQLserver 2008 on a Clustered environment.
• Installed and configured newSQLServer 2008 stand alone and failover database Server instances, SQL Server Integration Services (SSIS) and SQLServer Reporting Services (SSRS) for Development, Testing and Production Environment.
• Routinely Implemented SQLServer Integration Services (SSIS/DTS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in design of ETL packages for integrating data from heterogeneous sources like (Excel, Oracle, Flat file, CSV) by using multiple transformations provided by SSIS.
• Extensive experience in usingSQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports.
• Administered MSSQLServer security by enforcing security policy, Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Troubleshot and Improved SQLServer performance issues by RunningSQLProfiler, DMV, Performance Tuning Advisor and Activity Monitor.
• Enhanced performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.
• Implemented a DB maintenance plan for MSSQLServer (DBCC, updating index statistics, monitoring database and disk space) and running,SQLTracer andSQL Profiler.
• Strong experience in Database Backup, Backup compression, Restore and Disaster recovery procedures.
• Created and monitored automated scheduled Jobs.
• Implemented DB maintenance plan; Reorganizing and Rebuilding Index, updating index statistics, database Integrity checks.
• Implemented high availability strategy using Database Mirroring and Replication.
• Created and administered Database objects, tables, views, indexes, procedures for implementing some application functionality at the database side for performance improvement.
• Thorough analysis and testing of database objects & T-SQLstatements before deployment to the production server.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, task assignment and tracking.
• Hands on experience in Web Development.
• Strong Experience in writing complex T-SQL queries and SQL patching, updates, upgrades.
• Provided 24/7 technical support for troubleshooting and Database Management.