We provide IT Staff Augmentation Services!

Sql Server Dba / Application Dba Resume

OH

SUMMARY:

  • Microsoft SQL Server DBA with over 7+ Years of 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.
  • Over 7 years of professional experience as SQL Server Senior DBA/Developer and Maintained Production Servers related to Financial, Health Care, and Insurance.
  • 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 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.
  • 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.
  • 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.
  • 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).
  • Expertise in creating drill down reports, parameterized reports and Ad-Hoc reports using SSRS (2012/2008R2/2008).
  • 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.
  • Proven abilities in establishing effective task priorities, working independently and participating as an integral part of a team.

TECHNICAL SKILLS:

Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, MDS, Enterprise Manager, Query Analyzer, Performance Monitor, Database / Index Tuning Wizard, DBCC, Data Transformation Services, SQL Profiler, BCP, Event Viewer

ETL Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS), Import/Export Wizard

Databases: MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005, MySQL, Oracle, MS Access

Other Tools: Microsoft Visual Source Safe, IDERA, Lite-speed, RedGate, Spotlite, Sentry, Visual Studio, Report Builder, Crystal Reports, MS Excel, Visio, Erwin, TFS

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

Operating Systems: Windows 2003/2008/2012/2012 R2, Windows 98/NT/2000/XP/Vista/7, VMware, LINUX

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA / Application 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 need and provided Logistic support to Confidential /Defense from service provider BellInfo Solutions with series of contracts arranged through Zolon Tech Inc.
  • 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.
  • Experience with AWS RDS and Azure Paas is a plus.
  • 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.
  • Monitor the database systems to ensure secure services with minimum downtime (SQL Server 2008/2012/2014/2016 ).
  • 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 Oracle to SQL databases.
  • 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.

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, OH

SQL Server DBA / Application 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.
  • 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.
  • 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 .
  • 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
  • Performed Defragmentation Techniques for most complex indexes.
  • 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.
  • Made recommendations for space management and monitoring.
  • Production database support (24*7*365) on all versions.

Confidential, NJ

SQL Server DBA / Application DBA

Responsibilities:

  • Installation, configuration, upgrades & migration of SQL Ser ver 2008R2/2012 Enterprise Edition in Production & other lower environments. Applied latest service packs and windows patches.
  • Responsible for Critical server support 500 servers out of which 150 servers are production servers, remaining Prod like, test and development servers.
  • Experience deploying, managing, and operating scalable, highly available, and fault tolerant systems on AWS Services (EC2, RDS, S3, Glacier, Network, and ELB) and Microsoft Azure.
  • Experience on building out and improving the reliability and performance of cloud applications and cloud infrastructure deployed on Amazon Web Services, building the next generation of web applications and systems infrastructure, focusing on automation, availability and performance.
  • Expertise knowledge on implementing and controlling the flow of data to and AWS and selecting the appropriate AWS service based on compute, data, or security requirements.
  • 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 2012 Always ON High Availability in Windows Server 2012 64 bit environment based on requirement.
  • SQL Server 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.
  • 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.
  • Developing T-SQL scripts/PowerShell scripts/SSRS reports for database maintenance purpose.
  • Configuring Database Mail Service in MSSQL 2008/2008R2/2012 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.
  • 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.
  • 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.
  • Monitor the database systems to ensure secure services with minimum downtime (SQL Server 2008/2012).
  • Provide 24/7 support for critical situations & High Availability 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 Oracle to SQL databases.
  • 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.

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

Confidential, Chicago, IL

SQL DBA / Developer

Responsibilities:

  • Install, Configured SQL Server 2012, 2008, 2008R2 Enterprise & Standard editions on 32 and 64 bit systems.
  • Lead the team and used to train industry best practices to co DBAs and worked as scrum master in assigning tasks and reviewing them.
  • Assisted and closely worked with Architect team in setting up code standards, performing code reviews, evaluating additional resources to the existing/New applications.
  • Implemented and designed SSAS server, cubes, automated backup and restore using C# and XMLA scripts.
  • SQL Server 2012, 2008, 2008R2 Enterprise & Standard editions on 32 and 64 bit systems.
  • Implemented backup and restore strategy for SQL, SSAS production and DR environments using C# and T-SQL.
  • In order to Export a data from SQL to Csv file we use C# export csv cmdlet which is an alternative methodology for SSIS
  • 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.
  • Installed and Configured SQL Clustering (2node Active-Active) for Mission critical applications, Configured LogShipping/Mirroring to support adhoc reporting, Configured and Maintained SQL Server Replication (Snapshot, Transactional, Merge) to support the core application functionalities.
  • Configure/Maintain Backups using Litespeed in various environments supporting their needs.
  • Used various SQL inbuilt tools like SQL Profiler/Perfmon/Execution plans and 3 rd party tools like Confio Ignite, Idera, Redgate to track issues, identify bottlenecks and implementing solutions.
  • Worked extensively on Performance tuning, Code tuning, Query optimization, identifying hardware bottlenecks and allocating required resources etc.
  • Worked closely with software development team, Change control team, Development/QA/UAT teams ensuring the full integration and smooth functioning of the database portion of the environment.
  • Designed and configured SQL Security with help of ADGroups, SQL Roles for users, applications and assigning appropriate permissions to the databases.
  • Implemented enterprise level functionalities like Database Partitioning on Analytical systems for better performance.
  • Worked with co DBA’s to install strong proactive monitoring jobs to monitor the environments and generate the reports on daily basis.
  • 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.
  • Made recommendations for space management and monitoring.
  • Monitor, set and control system capacity plan for future system requirements.
  • 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.
  • Production database support (24*7*365) on all versions.

Environment: SQL Server 2012/2008R2/2008, MS Access, SSIS, SSRS, Lite-Speed, Ignite, ETL, .ASP, Windows 20012/2008/2003

Confidential

MS-SQL Server DBA

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.
  • Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
  • 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.
  • 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.

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

Confidential

SQL Server DBA/Developer

Responsibilities:

  • SQL Server 2005 Database Administration.
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005
  • Develop and implement replication, archiving and backup and recovery strategies
  • Hands on experience with Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation
  • Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
  • Provide 24/7 support for critical situations & High Availability Database support in On Call rotation.
  • SQL Server 2008, 2008R2, 2005 Enterprise & Standard editions on 32 and 64 bit systems.
  • Evaluated data storage considerations to store databases and transaction logs, shrinking the Transaction logs.
  • 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.
  • Restoration process testing from the backup server- by this we make a note of timing user to restore the archive files. This is done once a month to make sure the entire archive files for consistency.
  • Automated the Jobs responsible for the Daily backups of the System and Users Databases, Indexing, Fixing the Work Flow, Integrity check, Security Permissions, Shrinking Databases and created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, insufficient disk space and security breach.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • 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).
  • Analyzed long running slow queries and tune the same to optimize application and system performance.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Involved in generating various reports using the SQL Server Reporting Services.
  • Logical and Physical design of database for projects on basis of user requirements using ERWIN.
  • Wrote numerous stored procedures to perform data cleaning/loading task once data is loaded into staging area.
  • Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.

Environment: Windows 2000, MS SQL Server 2005/2000, T-SQL, MS Access, SSRS, Replication, Active/Passive Clusters

Hire Now