We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Chicago, IL

SUMMARY

  • 7 years of IT experience in the SQL Server DBA in Production, Development and Test Environments and BI Administration, Development using Microsoft SQL Server and BI suite (SSIS, SSRS, SSAS)
  • 24 X 7 Production Database on call Support.
  • Expert in installation and configuration of MS SQL Server 2014/2012/2008 R2 on standalone and cluster servers.
  • Experience on migrating the database from lower to higher environments.
  • Good Technical Knowledge on Always On.
  • Implemented Disaster Recovery Solutions by configuring mirroring, Replication and Log shipping clustering, Always On.
  • Expertize in database maintenance in Azure.
  • Good Technical knowledge on Azure.
  • Experience in Database Backup, Recovery procedures
  • Experience in Microsoft Cluster Services (MSCS), including Active/Passive, Active/Active
  • Experience in space allocation, database migrations and database security.
  • Experience in Capacity planning, Performance Tuning, Disaster Recovery and troubleshooting.
  • Recovery strategies for production environment.
  • Strong technical knowledge in MS SQL Server development including, SSIS.
  • Experience in controlling the user privileges, monitoring the security and Audit issues.
  • Excellent communication skills, analytical skills, understand business requirements in various domains.
  • Experience on SSRS report development using OLTP and OLAP systems.
  • Experience on SSRS report server maintenance.
  • Experience on SSIS ETL development to load the data from different source systems to SQL Server.
  • Experience on SSAS, SSRS, and SSIS administration.

TECHNICAL SKILLS

RDBMS: SQL Server 2016/ 2014/2012/2008 R2, Oracle, Teradata.

Operating Systems: Windows 2016/ 2012/2008 R2, Linux

SQL Server Utilities & Tools: SQL Management Studio (SSMS), SQL Profiler, Performance Monitor, BI Development Studio (BIDS), SSIS.

Analysis and Design Skills: Data modeling normalization, de - normalization, physical database design, relational models, star schemas, snowflake schemas

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sql Server DBA

Responsibilities:

  • Worked on SQL Server 2012 to SQL server 2017 migration.
  • Involved in SQL Server Cluster installation and configuration.
  • Involved in configuring the Always-on in production environments
  • Participated in BCP exercise.
  • Implemented, configured and troubleshooting Transactional Replication.
  • Worked on configuring BCP Environments and performing Real-time Failover Activities.
  • Involved in Performance tuning to tune the long Running Queries by analyzing query plans.
  • Involved in troubleshooting SQL Server locking, blocking and deadlocking.
  • Worked on Index Tuning and Optimization using Index Related DMVs.
  • Involved in Scheduling, Deploying and Troubleshooting SSIS Packages.
  • Analyzed performance issues and provide recommendations based on testing results or problems being experienced in production.
  • Performed refreshes between PROD, UAT and DEV environments.
  • Provided guidance to the development team on writing stored procedures and implemented the standards, guidelines and best practices for database development.
  • Worked on Change Data Capture (CDC) like INSERT, UPDATE, DELETE apply to Sql server tables, and makes a record available of what changed where, when.
  • Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
  • Managed SQL Server Clusters in Active-Active and Active-Passive Topology.
  • Involved in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
  • Invloved in service packs and
  • Involved in monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, and adding scheduled jobs to re-index and update statistics in databases.
  • Created elastic jobs in azure to archive and purge data and cross database querying.
  • Created Runbooks in azure using PowerShell to automate the maintenance jobs.
  • Configured Azure datafactory to maintain the SSIS packages in Azure
  • Experience in database performance tuning in azure databases.
  • Production Code Deployment and handling concurrent user requests.
  • Manage and maintain database changes in Development, QA, Staging and Production
  • Designed SSIS packages to load the data from different source systems
  • Designed SSIS packages to archive and purge the data.
  • Installed and configured SSRS (SQL server Reporting services).
  • Designed SSRS reports using matrix and tables
  • Created Sub-reports and main reports using matrix and tables
  • Designed complex SSRS reports on different source systems
  • Created an Integration Services package to extract data from a flat file using MS SQL Server Integration Services (SSIS).
  • Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.

Environment: s: SQL Server 2012/2016, Windows 2012, Azure, SSIS, SSRS, IDERA

Confidential, Dallas, Tx

Sql Server DBA

Responsibilities:

  • Daily support/maintain of databases in multiple environments
  • Involved in database migration from On-premise data center to the cloud.
  • Participate in Production Database on Call Support.
  • Participate in SQL Server Two node and Three-Node Cluster Configuration (Active/Active and Active/Passive) in SQL Server 216.
  • Collaborate with development team to push the code into UAT and PROD servers.
  • Work on Building BCP Environments and performing Real-time Failover Activities.
  • Participated in disaster recovery exercises to check application down time and issues
  • Participate in Configuring Always-On on production environment, using SQL Server 2016, for high availability and disaster recovery purpose.
  • Worked with OSE engineers to expand the server’s hardware to handle the load from applications and users.
  • Review the SQL Server stored procedures and recommended code changes to improve the query execution time.
  • Build and support CDC (Change Data Capture) functionality in SQL Server for data analytics team.
  • Work with developers in various tasks including query enhancements, automating jobs and running queries for developers where they do not have access.
  • Deploy reports in SSRS for various reporting project and maintain security and version of these reports.
  • Deploy DTSX packages for various systems, maintain packages and troubleshoot packages when there’s issue.
  • Patch SQL Servers with latest service packs and cumulative updates to keep servers in most updated version as possible for business needs or regular maintenance.
  • Database creation, writing database performance tuning scripts, backup planning and implementation with Database restore activity.
  • Involved in databases migrations from on-premise to azure servers
  • Created maintenance job and alerts in azure.
  • Write Stored Procedures based on business needs and review stored procedures written by the development team to make sure it’s optimized.
  • Creation and management of database maintenance plan for various database consistency checks. Evaluate database performance and performed tuning, backup, restoration and disaster recovery scenarios
  • Designed and developed packages for data warehouse using Integration services (SSIS)
  • Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
  • Created customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: s: SQL Server 2016/2012/, Windows 2012, T-SQL, Lite Speed, Spotlight, SSIS, SSRS

Confidential, Dallas, TX

Sql Server DBA

Responsibilities:

  • Participate in 24 X 7 Production Database On-Call Support.
  • Performs technical and functional requirements analysis, effort estimation, and resource planning to determine feasibility of proposed business solutions.
  • Work on installing and Configured Two-Node Cluster (Active/Active and Active/Passive).
  • Participate in implementing, configured and troubleshooting Snapshot and Transactional Replication.
  • Involved in Rebuilding/Monitoring the indexes at regular intervals for better performance.
  • Involved in performing database checks and maintaining the database health.
  • Monitoring and solving tickets on time which users raise in Service Now tool for support without missing SLA’s.
  • Configures and implements high availability and disaster recovery procedures in SQL Servers using Always-On and Database Replication.
  • Reviews and implements MS SQL Cluster (Active/Passive & Active/Active) and Multi Node Cluster.
  • Performs Tuning, Query Optimization, Database Mirroring configuration and other related troubleshooting support, including resolving database integrity issues, performance issues, connectivity issues, security issues, blocking issues & deadlocking issues, mirroring issues, replication issues, log shipping issues and Always-on issues.
  • Provides immediate and local technical onsite support for team members, applied expertise in enterprise database management systems tools and technologies.
  • Security Administration by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granted privileges to users and groups.
  • Identifying the data sources to be migrated and document everything for future use.
  • Provides recommendation for system improvements and possible solutions to support and maintains standards for quality assurance compliance. Coordinates changes to database and implement security measures as required. Develops and maintains proficiency in a range of database management technical and analytical tools as defined by company standards.
  • Employs effective communication techniques to collaborate with and provides project test and status reports to team members, direct supervisors and responsible managers, and to develop accurate documentation that complies with company standards.
  • Transferring the files/backups from SQL to other vendor sites using WINSCP FTP conversion.
  • Performed Database Refresh tasks from production to Development and Staging Servers.
  • Working in Data Encryption and Data Decryption for data security in Database & Column level.
  • Implemented the new SQL Server mechanisms like data compressions, online indexing, Contained Databases and security principals.
  • Follow the change management process to move database changes into production.
  • Performing the backups, restores, recovery models, Capacity planning, database shrink operations, DBCC commands. Can plan effective backup strategy as per the environment needs.
  • Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler, Ignite, Idera, and other related monitoring and troubleshooting tools.
  • Participated in disaster recovery exercises
  • Implemented high availability with Azure Classic and Azure Resource Manager deployment models.
  • Created reports in SSRS based on Teradata and sql server warehouse systems.
  • Created Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
  • Written stored procedures to use in SSRS reports.
  • Designed and developed packages for data warehouse using Integration services (SSIS)
  • Worked on BI Administration like maintain the SSAS cubes and SSRS reports (Report manager) and SSIS packages

Environment: s: SQL Server 2012, Windows 2012, T-SQL, Lite Speed, Spotlight and, SSIS, SSRS

Confidential

Sql Server DBA

Responsibilities:

  • Performed Production support in 24/7 and on Call duties.
  • Monitored and solving tickets on time, which users raise in Service Now, tool for support without missing SLA’s.
  • Performed technical and functional requirements analysis, effort estimation and resource planning to determine feasibility of proposed business solutions.
  • Migrating SQL server Mirroring, Log shipping, Replication and cluster setup environment to SQL Server 2012/2014 with Always on configuration on windows failover cluster.
  • Detected and troubleshot SQL Server related CPU, memory, I/O, disk space, and other resource contention.
  • Installed, configured and maintained appropriate database architecture and systems modules for enterprise-level projects, such as MS SQL Servers across Productions, QA, Staging and Development Environments.
  • Configured and implemented high availability and disaster recovery procedures in SQL Servers using Always-On and Database Replication.
  • Reviewed and implemented MS SQL Cluster (Active/Passive & Active/Active) and Multi Node Cluster.
  • Performed Tuning, Query Optimization, Database Mirroring configuration, and other related troubleshooting support, including resolving database integrity issues, performance issues, connectivity issues, security issues, blocking issues & deadlocking issues, mirroring issues, replication issues, log shipping issues and Always-on issues.
  • Provided immediate and local technical onsite support for team members, applied expertise in enterprise database management systems tools and technologies. Provided recommendation for system improvements and possible solutions to support and maintain standards for quality assurance compliance.
  • Coordinated changes to database and implement security measures as required.
  • Developed and maintained proficiency in a range of database management technical and analytical tools as defined by company standards.
  • Employed effective communication techniques to collaborate with and provided project test and status reports to team members, direct supervisors and responsible managers, and to develop accurate documentation that complies with company standards.
  • Written stored procedures and T-SQL queries to design the ad-ahoc reports
  • Involved in requirement gatherings to design the data model.
  • Created subscriptions in report manager
  • Created report caching in report manager
  • Created an Integration Services package to extract data from a flat file using MS SQL Server Integration Services (SSIS).
  • Created and scheduled SQL jobs to run SSIS packages daily using MS SQL Server Integration Services (SSIS).

Environment: s: SQL Server 2012, Windows 2012, T-SQL, Lite Speed, Spotlight and, SSIS, SSRS

Hire Now