PROFILE:

Microsoft SQL Server DBA with 7+ Years’ experience in Database Administration, Design, System Analysis, Develop and Implement solutions on SQL 2014/2012/2008 R 2/2008/2005/2000 , Technology Operations and technical skill set for handling very large scale, high availability database systems built on Microsoft technologies related to Financial, Health Care, and Insurance domain.

EXPERIENCE SUMMARY:

• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server ( 2014/2012/2008 R2/2008/2005) in standalone and cluster environments.
• Experience with Disaster Recovery Setup like SQL Clustering (active/active, active/passive), AlwaysON, Availability groups, SQL Replication, Mirroring, Log Shipping and HADR.
• Expertise in upgrading (In - place Upgrades) and migrating databases from MS SQL Server 2008 to 2014 and Consolidated DB’s using VMWare solution and thereby saving around 1 million USD in Licenses.
• Experience in supporting Very Large (VLDB), high Tran’s active databases and troubleshooting their performance bottle necks with SQL Server Profiler and Perfmon.
• Expertise in Performance Tuning/ Query tuning, identifying and tuning SQL Server Hardware bottlenecks.
• Experience in Oracle PL/SQL Development using various Oracle Key components such as Stored Procedures, Functions, Packages. DB Triggers, Views, Materialized Views, DB Links, Exception handling, Oracle Supplied Packages, Collections. Temporary Tables, (GTT), Bulk Load, Cursor, Ref Cursors, Partitioned Tables, Dynamic SQL, SQL Loader, Data Pump, UTL FILE, Database Links etc.
• Expertise in loading data from XML/FLAT Files into Oracle Database Tables using SQL Loader and External Tables.
• Experience in Monitoring Performance using various SQL Server inbuilt tools like Performance Monitor, SQL Profiler, Event Viewer, DMV’s/DMF’s, Execution plans, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries etc.
• Extensive experience with database administration, advanced data recovery, data corruption, capacity planning, extended SQL Server Internals & Server Memory and RDBMS concepts.
• Expert in creating various SQL server objects: Tables, Indexes, Indexed Views, Stored Procedures (Dynamic and Static), Functions and Triggers to facilitate efficient Data Manipulation and Data Consistency.
• Expertise in Oracle Data Pump commands like EXPDP and IMPDP for Data Migration.
• Extensive Experience in developing multi-threaded database processed using Oracle packages like DBMS SCHEDULER, DBMS STATS.
• Strong experience with Oracle DW, ETL, analysis for DOS, OLTP, and DW logical/physical, relational and multi-dimensional modeling (Sate Schema, Snowflake Schema), Optimization, Partitioning, Archiving and Capacity planning.
• Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, Normalization, Indexes etc.
• Expert in working with Third party backup tool like SQL Lite Speed, Idera SQL Safe, SolarWinds DPA for monitoring production environments, resolve bottlenecks & improve Performance of the application.
• Expertise in all SDLC phases and best practices like Oracle CDM and develop Methodologies and Guidelines.
• Experience in scheduling maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, tracing long running/deadlock queries, Capacity planning, Monitoring Tempdb, Cleanup tasks, Disaster recovery solution maintenance etc.
• Experience in applying SQL Server database service packs, hot fixes and security patches.
• Extensive experience in handling security issues, maintaining Database Authentication Modes, Creation of Users, Configuring Permissions and Assignment of user roles as per enterprise policy.
• SSIS - Extract, Transform and Load data from various heterogeneous data sources like Access, Excel, CSV, Oracle, Flat File and Text Format Data, Teradata using OLE DB connection by creating various SSIS packages.
• Good understanding of RDBMS, Oracle Database architecture, designs and having performed DBA duties, such as Table Partitioning, Export/Import and Data Pump.
• Experience in working with Normalization and Denormalization databases for reducing redundancies and dependencies.
• Excellent knowledge in creating custom specific and schedule reports using SQL Server Reporting Services (SSRS).
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in designing, creating, processing of Cubes using SSAS and using MDX Queries.
• Experience in data warehouse modeling (designing Star Schema, snowflake schemas with identifying Facts and Dimensions).
• Worked with the version control tools like Microsoft Visual Source Safe (VSS) and Team Foundation Server (TFS).
• Conversant with full SDLC involving System Analysis, Design, Development and Implementation.
• Ability to work in team environment with excellent communication, presentation, leadership. Analytical, qualitative and interpersonal skills.

TECHNICAL PROFICIENCY:

Databases: MS SQL Server 2017/2016/ 2014/2012/2008 R2/2008, MySQL, Oracle (11g/12c/18c/19c), Teradata, MS Access.

Reporting Tools: Sql server reporting services(SSRS), Sql server Integration services(SSIS), Sql server Analysis services (SSAS)Database tools: Sql Server Management studio (SSMS), MDS, Enterprise Manager, Query Analyzer, Performance Monitor, Database Index tuning wizard, Facets, DBCC, Data Transformation services, Event Viewer, SQL Profiler.

Languages: SQL, T-SQL, PL/SQL, C#, HTML, XML, ASP.NET, PER.

Operating Systems: Windows 2008/2012 R2, VMware, Linux.

Other tools: Microsoft Visual Studio, Microsoft Visual Source Safe, Redgate, Solarwinds, Idera, TFS, MS Excel, Erwin.

CAREER PROGRESSION:

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Installation, configuration & migration of SQL Ser ver 2008R2/2012/2016 Enterprise Edition in Production & other lower environments. Applied latest service packs and windows patches.
• Responsible for Critical server support 50 servers out of which 15 servers are production servers, remaining Prod like, test and development servers.
• To manage and handle very large sized databases, size of each is about 3TB in production, development and Test environment.
• Regular checkup of automated daily, weekly and monthly maintenance tasks such as backups, update statistics, consistency checks and rebuild indexing.
• Implementation of SQL Server 2016 Always ON High Availability in Windows Server 2012 R2 64-bit environment based on requirement.
• Created Logins, Users and assign permissions based on the level of database access the user would require them.
• Analyze, document and present all related security, architectural, and operational requirements applicable to develop possible solution sets.
• Involved in Data modeling, designing, and building relational databases.
• To fine tune queries for betterment of SQL performance we use DBCC commands, DMV’s and DMF’s .
• Monitoring and Performance tuning, Physical Server Level, Database level (Database settings and options) and query tuning . (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.)
• To perform capacity planning and database sizing for production servers.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Cloud/Azure experience includes Azure Services, PaaS, IaaS, and Migrated from premises databases and Legacy databases to Azure, deployed products on Azure, Setup development and test environment on Azure.
• Manages and maintains all Teradata production and non-production databases
• Responsible for Teradata standards and design of physical data storage, maintenance, access and security administration
• Responsible for maintaining the availability of Teradata database version TD14 databases in a production and non-production environments
• Define Teradata database architectures and strategies to meet application availability, scalability and performance requirements.
• Strong knowledge of Teradata Tools and Utilities, pertaining to ETL, Operating knowledge of Teradata tools and utilities.
• Supporting Teradata database migration activities
• Implements best practices for system and data administration functions for complex, multi-system, multi-platform network on Windows, UNIX and Linux based platforms.
• Experience in administering servers in multiple operating systems like UNIX, Linux and Windows.
• Developing T-SQL scripts/PowerShell scripts/SSRS reports for database maintenance purpose.
• Configuring Database Mail Service in MSSQL 2016/2012/2008 for SQL Agent Job Notifications.
• Creating, Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Working with XML, SQL queries, SSIS, web services, import/export data validation.
• Deploying and troubleshooting SSIS/DTS packages with a multitude of Data sources and complex data conversion logics.
• Backup and recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes, Functions, Stored Procedures and referential integrity depending on user requirements and converting them into technical specifications.
• Provide 24/7 support for critical situations & Database support in On Call rotation.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from different version of Oracle 11c/12c/18c to SQL databases.
• Interface with Oracle corporation for technical support to perform application tuning and performance monitoring.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring, SQL Server clustering & configured Snapshot and Transaction Replication.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity Issues and backend performance issues.
• Performed Defragmentation Techniques for most complex indexes.
• Expertise in working with ITIL processes including change, problem and incident management.
• Testing facets core application and UAT modules by following standard testing procedures.
• Building testing environment and testing scripts by referring technical specifications.
• Expert in Healthcare testing, FACETS product, EDI transactions.
• Responsible for administration, development and support of web-based application running PHP and Peril on Apache with Informix, My Sql and MSSQL databases.
• Perl development using OO and ORM layers in MVC/N-Tier Environment.
• Developed and refactored SQL for both My SQL and Oracle environments.

Environment: SQL Server 2016/2012/2008 R2/2008, MS Access, SSIS 2008/2012, SSRS 2008R2/2012, DB2, Oracle 9i/10g, Visual Studio 2012/2013, VBA, XML, XSLT.

Confidential, Ohio

SQL Server DBA

Responsibilities:

• Installation, configuration, upgrades & migration of SQL Ser ver 2008R2/2012/2014 Enterprise Edition in Production & other lower environments. Applied latest service packs and windows patches.
• Responsible for Critical server support 50 servers out of which 15 servers are production servers, remaining Prod like, test and development servers.
• To manage and handle very large sized databases, size of each is about 3TB in production, development and Test environment.
• Used PL/SQL to create Packages, Functions and Stored Procedures, to achieve the functionality and use case based on business requirement and logic.
• Design of SFTP process and writing of Shell scripts to process data from other systems.
• Used Bulk collections for better performance and easy retrieval of data by reducing context switching between SQL and PL/SQL engines.
• Responsible for Teradata standards and design of physical data storage, maintenance, access and security administration
• Responsible for maintaining the availability of Teradata database version TD14 databases in a production and non-production environments
• Define Teradata database architectures and strategies to meet application availability, scalability and performance requirements.
• Experience with working different version of Teradata 14.10 or higher, and having Operations Database support experience.
• High level of SQL troubleshooting skills with knowledge in MSSQL Server, Teradata, Teradata Viewpoint.
• Regular checkup of automated daily, weekly and monthly maintenance tasks such as backups, update statistics, consistency checks and rebuild indexing.
• Implementation of SQL Server 2014 Always ON High Availability in Windows Server 2014 64-bit environment based on requirement.
• Created reports in OBIEE Tool. Creating complex graphs using XML and chart.
• As a dual role of DBA and Developer implemented changes performance improvements.
• SQL Server 2014, 2012, 2008, 2008R2 Enterprise & Standard editions on 32 and 64 bit systems.
• Created Logins, Users and assign permissions based on the level of database access the user would need.
• Involved in Data modeling, designing, and building relational databases.
• To fine tune queries for betterment of SQL performance we use DBCC commands, DMV’s and DMF’s .
• Created/modified Oracle objects like user defined data types and using SQL Developer Data Modeller data modelling tools to design and maintain Conceptual, Logical and Physical Database models.
• Responsible for Data Migration using Oracle tools like Expdp, Impdp and RMAN.
• Monitoring and Performance tuning, Physical Server Level, Database level (Database settings and options) and query tuning . (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.)
• To perform capacity planning and database sizing for production servers.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Developing T-SQL scripts/PowerShell scripts/SSRS reports for database maintenance purpose.
• Configuring Database Mail Service in MSSQL 2014 for SQL Agent Job Notifications.
• Working with XML, SQL queries, SSIS, web services, import/export data validation.
• Deploying and troubleshooting SSIS/DTS packages with a multitude of Data sources and complex data conversion logics.
• Expertise in Installing, configuring SSIS, SSRS, SSAS, deploying SSIS packages, reports and configuring Cubes and dimensions and trouble shoot the issues and identifying the root causes etc.
• Backup and recovery of production databases and tuning them for better performance.
• Used various SQL inbuilt tools like SQL Profiler/Perfmon/Execution plans and 3 rd party tools like Solarwinds, Redgate DLM Dashboard to track issues, identify bottlenecks and implementing solutions.
• Migrated the repository of the TFS for ETL and Maintenance pans from Visual studio 2012 to 2013.
• Assisted and closely worked with Architect team in setting up code standards, performing code reviews, evaluating additional resources to the existing/New applications.
• Scheduled maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, tracing long running/deadlock queries, Capacity planning, Monitoring Tempdb, Cleanup tasks, Patch and hotfix installations, Disaster recovery solution maintenance etc.
• Production database support (24*7*365) on all versions.
• Assigning the tasks of performing regression testing of facet application.

Environment: SQL Server 2016/2014/2012 , SSIS 2012, SSRS 2012, Visual Studio 2012, Oracle 12C/18c, E-R Win 6.x, Bitbucket, ERWIN.

Confidential

SQL DBA/Developer

Responsibilities:

• Installed SQL Server 2008 in production, test and development environments.
• Managed servers in Clustered, Mirrored and Log Shipping environment
• Managed SQL Servers in Virtual and Standalone environments for OLTP and DSS systems
• Expertise in Installing, configuring SSIS, SSRS, SSAS, deploying SSIS packages, reports and configuring Cubes and dimensions and trouble shoot the issues and identifying the root causes etc.
• SQL Server 2012, 2008, 2008R2, 2005 Enterprise & Standard editions on 32 and 64 bit systems.
• Provide 24/7 support for critical situations & High Availability Database support in On Call rotation.
• Designed high level ETL Architecture for overall data transfer from the Source Server to the Enterprise Services Warehouse. Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Designed and implemented complex SSIS package to extract data from multiple data sources for analyzer.
• Designed high level ETL Architecture for overall data transfer from the Source Server to the Enterprise Services Warehouse.
• Designed and Developed Complex SSIS packages using SQL SERVER 2008 Integration Services, OLEDB, file system task, ftp task in SQL SERVER Integration Services to upload and download the ETL DATA.
• Extensive subject matter expertise in IT Services Management (ITSM) & ITIL, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.
• Performs corrective and preventive maintenance for installed SCADA systems.
• Designed and implemented database changes.
• Reviewed and tune up SQL queries, stored procedures, views and triggers.
• Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
• Help in-house developers improve performance of their stored procedures, TSQL codes and database design.
• Managed health of SQL Servers including backups, restores and monitoring.
• Provide a working model of transaction processing environment for capacity assessment and planning.
• Used SSRS to report exceptions and data analysis reports.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.
• Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.
• Responsible for coordination of installation and customization of SCADA systems and automation using cimplicity.
• Generate and maintain detailed technical documents as required during the course of project development.

Environment: MS SQL Server 2008R2/2008/2005, SSIS, SSRS, MS-Office, Access, DTS, T-SQL