We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

Houston, TexaS

PROFESSIONAL SUMMARY:

  • 10+ years of IT professional experience as Microsoft SQL Server 2017/2016/ 2014/2012/2008 R 2/2008/2005/2000 installation, configuration and administration for cluster and non - cluster servers.
  • Professional experience as on Oracle 12c/11g/10g/9i production support activities.
  • Professional experience in the Analysis, Design, Development and implementing in Business Intelligence (SSIS, SSRS, and SSAS).
  • Expertise in SQL Server Upgrade, Migration and applying Cumulative updates and Service Packs.
  • Experienced in managing the Security for the Database. Created SQL Server logins, users, database-level roles, schemas, and access permission.
  • Hands-on experience in troubleshooting Database in Windows Azure & AWS.
  • Having a fair understanding of SSMS, SSCM, SSIS packages, SSRS and SSAS.
  • Experienced in installing and maintaining in 2 - Node Active/Passive and Active/Active SQL Server Clustered environment.
  • Designed, implemented and maintained of SQL Server databases including security, back-up, logging, reporting, and recovery procedures.
  • Experienced in Configuring High Availability & Disaster Recovery concepts like (Always on High Availability, Log Shipping, Mirroring, Clustering, and Replication).
  • Monitored and maintained production servers, analyzed and resolved database performance issues, tuned queries, backup/restore and enabled TDE.
  • Ensure database back up processes and schedules meet defined Recovery Point Objectives (RPO) and that backups are routinely tested to ensure consistency and the ability to meet Recovery Time Objectives (RTO).
  • Power Shell, AD, SSDT, Azure, Windows Server and in general deep Microsoft system implementation skills.
  • Excellent skills in implementing ETL Packages using DTS and SSIS 2016/2014/2012/ 2008/2005.
  • Experienced in T-SQL & SQL Developer (DDL, DML) documentation, programming, and implementation of Business Intelligence solutions.
  • Hands on experience in writing and debugging Stored Procedures, Views and Complex queries using T-SQL .
  • Experienced in resolving SQL Server performance issues using Profiler, DBCC, DMVs, SQL Execution plans and Perfmon.
  • Experienced in enabling Change Data Capture (CDC) for table objects in critical databases.
  • Experienced in managing Alerts, Operators, and SQL Jobs through SQL Server Agent.
  • Monitored and responded to alerts from SCOM and SQL Diagnostic tool .
  • Experienced in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle.
  • Involved in implementing and troubleshooting on Replication in SQL Server in a high OLTP environment.
  • Daily system health checks (Space, CPU, Memory, Table statistics, indexes, and logs ) and sending out daily reports.
  • Taken part in the process of moving the databases from development to production (Go live) and Database Refreshes.

TECHNICAL SKILLS:

Operating Systems: Windows and Red Hat Linux

Database: MS SQL Server 2017/2016/ 2014/2012/2008 R 2/2008/2005/2000, Oracle 12c/11g/10g/9i/8i, Windows Azure (Cloud), AWS Cloud, and MS Access.

Database Tools: SQL Data Tools, SQL Server Management Studio (SSMS), SSCM (SQL Server Configuration Manger), Analysis Services (SSAS), ApexSQL, SQL Server Migration Assistant (SSMA), DMA, DMS, Visual Studio, Query Analyzer, and SQL Profiler.

Languages: T-SQL, PL/SQL, VB.NET and C#.NET

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Import/Export Wizard, SQL Server Reporting Services (SSRS), and SQL Server Data Tools (SSDT).

Applications: Microsoft Office (Excel and Visio)

Others: VMWare, Power Shell, Active Directory, Lite Speed, Redgate, SCOM, SQL Diagnostic Manager tool (IDERA), OEM, TFS (Team Foundation Server), DBdefence Encryption Tool, dbforge SQL Decryptor, and Data flow diagrams.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

Sr. SQL Server DBA

Responsibilities:

  • Design ing, instal ling, upgra ding, administrating, securing and monitor ing SQL 2017/2016/ 20 14 /2012 /2008 databases in the cloud on Cluster and non-cluster environments.
  • Migrating to MS SQL Server 2000 to SQL 2005/2008/2012/2014/2016/2017 using side by side approach.
  • Migrating the on-premise SQL Servers to virtualize environments (VMWare).
  • Architect and Consultant with system/operations analysis, hardware and software design, development, design database models, implement software.
  • Migrated legacy databases to AWS cloud (RDS/EC2) from SQL Servers.
  • Migrated objects through import/export to AWS cloud.
  • Implementing of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Troubleshoot ing SQL Server related CPU, memory, I/O, disk space, and other resource contention.
  • Maintaining and troubleshooting on 2-node Active/Active SQL Server 2008/2012 Clustering.
  • Installed and configured Multi-Instance SQL 2008 Failover Cluster on Windows 2008 Server Cluster.
  • Configuring and troubleshooting High availability feature of Alwayson in SQL Server 2012/2014.
  • Implementing and troubleshooting in configuring Replication, Mirroring, Log Shipping, and Alwayson .
  • Created master keys, certificates and private keys for transparent Data encryption (TDE).
  • Enabled SQL Native encryption of TDE for critical databases which contains SSN information to one of the critical business units.
  • Writing PowerShell to automate redundant tasks. Enabling the quorum by using power shell scripts whenever datacenter failover requires.
  • Designed and developed SSIS packages and implemented Incremental / Full load extracting data from various sources, applied business logic using different transformations like Lookup, Derived Column, Script Component, SCD, Data Conversion, and Multicast.
  • Using SSRS tool generated periodic reports based on the statistical analysis of the data.
  • Developing and maintaining SSAS OLAP cubes. Maintaining existing Data warehouse/Data objects/marts and creating new based on requirement.
  • Skilled in error and event handling, Implemented checkpoints, breakpoints, event handlers, troubleshooting, and error handling in SSIS packages to improve usability and liability.
  • Working knowledge of Agile/Scrum Environment and used TFS (Team Foundation Server).
  • Designing, writing and troubleshooting T-SQL Code (Stored procedures, functions, tables, views, triggers, indexes, constraints).
  • Performance tuning of ETL transformations(SSIS/XML), workflow and Implemented slowly changing dimensions to maintain current information and history information in dimension tables for Data Warehousing.
  • Extensive experience in effective requirement gathering and creating user stories for various web applications while working in a fast-paced Agile environment.
  • Monitoring database space requirements and performing Database health checks.
  • Participate in sprint planning sessions, retrospective meetings, daily standup meetings, and other agile activities .

Environment: SQL Server 2017/2016/ 2014/2012/2008 R 2/2008/2005/2000, Windows Server 2012R 2/2012/2008/2003, Linux, Oracle 11g/12c, OEM, AWS, Azure, T-SQL, TFS, Redgate, DBdefence Encryption Tool, dbforge SQL Decryptor, Query Analyzer, Power Shell, SQL Profiler, SSMS, SSIS, SSRS, SSAS, and Service Now Tool.

Confidential, Redmond, WA

SQL Server DBA Lead

Responsibilities:

  • Design ed, instal led, upgrade d, administer ed, and monitor ed SQL 2014/2012/ 2008 databases in Windows Azure Cloud, Cluster and non-cluster environments.
  • Upgrade d /Migrated of MS SQL Server 2008 /2008R2 to MS SQL Server 2012/2014 using any suitable approach (in place or side by side).
  • Migrated schemas to windows azure from SQL server using PowerShell scripts.
  • Created relays in service bus in Windows Azure to connect On-Premise Web server.
  • Maintained and troubleshooting on 2 - node Active/Passive and Active/Active SQL Server 2008/2012 Clustering.
  • Configured and troubleshooting Alwayson High availability in SQL Server 2012 .
  • P2V and V2V migration of virtual servers.
  • Responsibilities taken include the Production and Application Support for the Database and Application Servers.
  • Enabled CDC for table objects and data encrypted the critical databases with SQL native TDE.
  • Used DMV for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes for query/stored proc edures tuning.
  • Provide d leadership for DBA project design, implementation, and transitions as required.
  • Configur ed and maintained Database Mirroring, Replication and Log Shipping.
  • Participated in daily meetings with Team folks and clients as well in the ongoing process and upcoming.
  • Created Documentation, schema designing, and MS Visio and involved in architecture.
  • Created Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio.
  • Designed and developed SSIS packages and implemented Incremental / Full load extracting data from various sources, applied business logic using different transformations like Lookup, Derived Column, Script Component, SCD, Data Conversion, and Multicast.
  • Experienced to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention .
  • Application support for front-end feeds and Resolved application connectivity issues like connection timeouts, connection pooling issues, and memory leaks.
  • Experienced in techniques such as SPRINT planning, Product Backlog management, agile estimation, daily SCRUM, metrics such as Burn-down & Velocity charts, Sprint summary report, Sprint review/retro meetings.
  • Assigned tickets to the team and tracking the status of the ticket in ITSM.
  • Taken ownership on primary database as a senior DBA and lead by example.

Environment: SQL Server 2014/2012/2008 R2/2008, Windows Server 2008/2012, Windows Azure, TDE, SSIS, SSRS, SSAS, Power Shell, SSMS, Microsoft Visio, SQL Profiler, SCOM, Perfmon, T-SQL, Litespeed and ITSM Tool.

Confidential, Raritan, NJ

Sr. SQL Server and Oracle Database Administrator

Responsibilities:

  • Installed, configured, administrated, secured and maintained SQL Server 2008R2/2008/2005 instances and databases.
  • Applied latest service packs, hotfixes and cumulative updates on a production server.
  • Upgraded/Migration of MS SQL Server 2005 to MS SQL Server 2008/2008R2 using any suitable approach (in place or side by side).
  • Installed, configured, administrated of SQL Server Cluster 2005/2008.
  • Helped on Critical tickets for Database L1 team and L2 Team.
  • Followed change management process and participate in related meetings.
  • Maintained and troubleshooting on 2-node Active/Passive and Active/Active SQL Server 2005/2008 Clustering.
  • Created and maintained database architecture and standards following SQL server Best practices for physical structures, logical databases, user management.
  • Transferred knowledge to coworkers through the development of procedures and documentation of all relevant products.
  • Installed and Upgraded of Oracle software in all flavors of Unix and Windows.
  • Implemented of Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Refreshed activities (exp/imp, expdp/impdp and RMAN).
  • Managing backup and recovery(RMAN and user-managed). Troubleshooting backup issues.
  • Performed Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
  • Created Schema, tablespace, file system and segment management.
  • Worked on Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Followed the existing processes for SOX and Non-SOX regulations.
  • Enabled Change Data Capture (CDC) for table objects and Transparent Data Encryption (TDE) for databases in SOX servers.
  • Configured and troubleshooting Log Shipping, Replication and Database Mirroring.
  • Responded to all requests from the team, project leads and the database manager in a timely fashion.
  • Participated in daily meetings with team folks and clients as well in the ongoing process and upcoming.
  • Monitored the overall performance of the Database servers and recommending actions to improve/optimize performance.
  • Experienced in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle.
  • Maintained RCA for Priority Ticket (P1) and updating the documentation.
  • Tested the functionality of backup tool Redgate to see if that fits our environment.

Environment: SQL Server 2008R2/2008/2005, Windows Server 2008/2003, SSMS, SSIS, SSRS, Oracle 11g/10g/9i, T-SQL, Windows Server 2003/2008, Oracle Linux, Oracle Enterprise Manager, Query Analyzer, SQL Profiler, LiteSpeed 6.0, SQL Diagnostic Manger tool (IDERA), HP Service Center, and Redgate .

Confidential, Austin,TX

SQL Server Database Administrator

Responsibilities:

  • Installed, configured, administrated, secured and maintained SQL Server 2005/2000 instances.
  • Administered 1000+ SQL Servers 2005/2000 instances in Production, QA and Development Environment.
  • Upgraded/Migrated to MS SQL Server 2000 to MS SQL Server 2005 using any suitable approach (in place or side by side).
  • Implemented of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Monitored the status of Maintenance jobs - scheduled to run daily and on weekends (tasks like rebuilding indexes, fragmenting Databases, and database backups).
  • Participated in a team meeting on a Bi-weekly basic for a discussion on the ongoing process and upcoming.
  • Exported or Imported of data from other data sources like flat files using Import/Export of SSIS Package.
  • Configured and maintained database replication (Snapshot and Transactional) and Log Shipping.
  • Provided 24x7x365 support for Production, Development, and UAT of MS SQL Servers.

Environment: SQL Server 2005/2000, Windows Server 2003, T-SQL, Query Analyzer, SQL Profiler, DTS and Remedy Tool.

Hire Now