We provide IT Staff Augmentation Services!

Sr Sql Server Dba Resume

CaliforniA

SUMMARY:

  • Confident, competent, client - oriented Microsoft SQL Server Database administrator Professional with 9 years of experience in IT industry augmented by a master-level education in Computer Science. Policing and managing mission-critical database systems in large distributed enterprise environments, automating tasks to cut the manual work and increase the productivity.
  • Experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 7.0/ 2000/ 2005/2008/2008 R 2/2012/2014/2016 in Enterprise Production, UAT, SIT, Test, Development Environments.
  • Experience in Installing, Configuring, Managing, Upgrades (In place Upgrade and side-by-side), Migrations (From SQL cluster setup environments to SQL Always on Availability (AOA)), Monitoring and Troubleshooting of SQL Server 7.0/ 2000/ 2005/2008/2008 R 2/2012/2014/2016 .
  • Expertise in setting up/installing High availability environments like active-active and active-passive SQL clustering on windows clustered server 2003/2008/2012/2012 R2, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping and Always On Availability (AOA).
  • Part of data warehouse design and development using SQL server and Micro Strategy reporting solutions for immediate needs and also planning to migrate from DW SQL server solution into Netezza.
  • Expertise in Database maintenance, performance tuning, optimization, backup/restore, disaster recovery, migration, monitoring, security planning and trouble-shooting high availability related issue.
  • Extensive knowledge and experience in SQL Management Studio, Enterprise Manager, Query Analyzer, Business Intelligence development studio, report builder 2.0, rescheduling jobs with SQL Server Agent, SQL Profiler, OLAP, OLTP, trouble shooting.
  • Experience in planning and executing disaster recovery (DR) exercises on the DR servers and supported failover/failbacks.
  • Expertise on Implementing High Availability options with Zero Data Loss and real-time apply environments.
  • Well equipped with the working knowledge of application development life cycle methodologies, database and application performance tuning.
  • Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
  • Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
  • Experience in troubleshooting SQL issues by using SQL Tool, Execution Plans, Trace, Statistics, and Index tuning wizard.
  • Expertise in H/W SAN & RAID levels configurations and placement of database data/log files across different drives.
  • Experience in using methods like Bulk Copy (BCP) and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS), SQL Server Reporting Services SSRS, SQL Server Analysis services SSAS in MS SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016
  • Master in performing administrative tasks like database files management, backup/restore, save backups to tapes, security management, data integration, Data Masking, Data Encryption and synchronizations.
  • Expertise in moving the system databases from one storage to another (ex: from xtremio to vmax).
  • Experience with third party tools like Delphix (Virtual database backup and restore), Attunity Tool (Replication SQL to SQL and SQL to Netezza), and Monitoring tools like Data Performance Analysis (DPA), Ignite, and Splunk, Encrypting tools like Vormetric, Backup and restore with Lite speed, Idera and SQL Comparison tools Red Gate.
  • Experienced in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS Packages.
  • In-depth knowledge of T-SQL (DDL and DML) to perform batch processing and implement business logics into backend.
  • Involved in gathering business requirements, interacting with the client/application team and preparing detailed design documents with architectures. RCA for prod issues are documented and submitted to postmortem team.
  • Strong experience in mentoring and working with different teams, coordinating with developers, application team, good communication skills documentations, supporting architects, decision support meetings and 24/7 on call support.
  • Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.
  • Proactive, independent, self-managing and teamwork spirits and ability to support critical business requirements.

TECHNICAL SKILLS:

Relational Databases:: SQL Server (7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016), MS AccessQuerying/Reporting: T-SQL, PL/SQL, SQL * Plus, SQL*Loader, TOAD.

Reporting Tools:: SSRS, Power BI, Cognos 8, Microsoft Clustering Services (MSCS), Crystal Reports.

Modelling Tools:: SQL Server Analysis Server (SSAS), ER-win.

ETL Tools:: Microsoft Integration Services (SSIS), Cognos Decision Stream.

Programming Languages:: C, C++, JAVA, PL/SQL, .Net, PowerShell.

Documentation Tools:: Latex, MS Office (Including MS Project, VISIO)

Operation Systems:: Windows (98, 2000, 2008 R2, 2012, 2012 R2, NT, XP), UNIX, Macintosh.

Performance Tools:: Database Performance Analyzer, Ignite Tool, Red-Gate SQL Monitor, Ideras, SQL diagnostic manager, Microsoft SQL Server Profiler, Microsoft SQL Server Database Engine Tuning AdvisorOther Tools: Red Gate, Delphix, Attunity for Replication, UCSD Tool, Scalr Tool, Jira, RSScripter

PROFESSIONAL EXPERIENCE:

Confidential, California

Sr SQL Server DBA

Responsibilities:

  • Migration of the SQL 2008 R2 Cluster setup to SQL Server 2014 SP1 CU5/ SP2, 2016 SP1 with Always on Availability AOA configuration on windows failover cluster server 2003/2008/2012/2012 R2.
  • Installed and configured active-active and active-passive SQL server 2008 r 2/2012/2014 4 node and 6 node clustering for Critical applications. Configured and trouble-shoot the (AOA) Always on Availability for different environment for SQL Server 2012/2014/2016.
  • Experience in installation, Upgrades (In place Upgrade and side-by-side) and configuration of MS SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005 versions on both Standalone and Cluster Environments.
  • Assisted in architecture, planning and implementation to maintain a highly availability/Tier1 infrastructure and worked with team members and Application Teams collaboratively for resolving any DB performance issues/database issues.
  • Worked on planning for DR (Disaster Recovery) and implementation of Disaster Recovery.
  • Desiging,Manging and supporting all 600+ SQL server Instances ( Cluster, Virtual etc. ) for different environments (DEV/SIT/UAT/Staging/PROD) and have experience in managing the VLD (Very Large Databases- sizes: 2-15 TBs)
  • Worked on managing and building the virtual servers for different environments ( DEV/SIT/UAT/Staging/PROD) using scalr and UCSD.
  • Worked on mentoring and setting up high availability environments with Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping setting up from scratch on clustered environments and also used 3rd party tool for replication Attunity ( CDC and Full Load replications)
  • Apply SQL Server software maintenance upgrades and fixes for current and past versions, ability to monitor and react to system-down situations.
  • Worked on Configuring and setting up of daily databases refreshes for ETL and Reporting using Delphix and Attunity, SSIS, SSRS and tools like Performance Analysis, Spotlight, and Lite Speed .
  • Installed and Migrated SQL Server Reporting services, SQL Server Integration and SQL Server Analysis services 2005/2008/2008 R 2/2012/2014/2016 . Created SSIS packages to import data from MS Access, Excel to SQL Server and Created report models and deployed on report server using SSRS.
  • Worked on different projects (CRM, PORTAL, Care systems, Claims, QNXT,HEDIS) and multiple domains (MMS, MHI, DMZ, and QA) experience in Performance Tuning, Query Optimization and analyzing query plans. Created missing indexes, update statistics, rebuild\reorganize indexes. Troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics, and Index tuning Wizard.
  • Worked on cleanup of large scale databases (3000) on DEV/SIT/UAT/Staging with coordinating with project teams and retrieved storage of 15 TB.
  • Closely worked with storage team, network team, server engineering team for any issues and delivered the servers/databases and even migrations/upgraded on time, and a part of tiger team.
  • Proactively worked on Production issues, extensively involved in DB performance tuning, troubleshooting and provided on-call 24*7 support.

Environment: MS SQL Server 2016/2014/2008 R2/2008/2005, Windows 2003, 2008 R2, 2012, 2012 R2,Red Gate, Ignite Performance, Delphix, Attunity, Jira, Netteza, TFS, SSRS, SSIS, SSAS, Idera, Light speed, DPA, PowerShell, V-block, SAN Storage, Veritas Backnet, NetBackup, Visual Studio, tableau(Business Intelligence and Analytics), Vormetric (disk level Encryption),Splunk, App Dynamics, Jet Stream, Data Masking, RSS Scripter.

Confidential, South Dakota

SQL Server DBA

Responsibilities:

  • Installed and configured SQL Server 2008 R2/2012 SP1 (Enterprise, Standard and Development Edition) on different environments (DEV/SIT/UAT/Staging/PROD) and involved in latest Security updates involving Service Packs and Security patches.
  • Migrated standalone SQL Server 20 R2 to AOA (Always On availability) SQL Server 2012 SP1 Tier1 applications on windows clustering. Created availability groups and delivered Listener names to application team.
  • Installed active-passive 4-node SQLClustering 2012(SP1) Enterprise Edition on Windows clustering server 2012 for PROD/Staging Environments.
  • Refreshed nightly refreshed jobs and scheduled jobs using Replication Manager, Atunity Replication and using SQL server agent job for 20+ servers and troubleshooted the replication issues.
  • Implemented DR (Disaster Recovery) plan on Tier 1 Applications. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
  • Worked in Configuring High availability features like Database Mirroring, Replication (Snapshot, merge, transactional) and Log shipping on SQL Server.
  • Experience in performance analysis and production support for very large (VLDB) and complex databases, and recovered databases from corruption.
  • Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing (re-build indexes, re-organize)/tuning the performance of SQL Server.
  • Worked in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and added Indexes to improve performance on tables.
  • Created and used Tables, Views, Indexes, Stored Procedure and Triggers, used multiple join statements to retrieve data from multiple tables.
  • Involved in large scale of production deployments using TFS, on weekly basis and attending CAB Meetings.
  • Created Linked Servers between SQL Servers and also to Oracle Databases, DB2 and Postgres.
  • Configured Security at Active Directory and SQL Server level by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions). Creation of schema objects, granting roles and privileges to the users, compilation of procedures etc.
  • Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
  • Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
  • Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files. Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
  • Providing Primary DBA (24X7) support to databases in stage and production environment.

Environment: MS SQL Server 2012 SP1/2008 R2/2008/2005, Windows 2003, 2008 R2, 2012, 2012 R2, Fog Light, Spotlight, Red Gate, Ignite Performance, Jira, TFS, SSRS, SSIS, SSAS, Idera, Light speed, DPA, PowerShell, V-block, SAN Storage, Veritas Backnet, NetBackup, Visual Studio, TFS, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Database Maintenance Plan Wizard, Data Transformation Services (DTS) App Dynamics, Data Masking, Idera

Confidential, Phoenix, AZ

SQL Server DBA

Responsibilities:

  • Resource planning and coordination for application migrations with project managers, application and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third party applications based on SQL 2000 in upgrade project to SQL 20 R2
  • Responsible for installation, Migration, up gradation of SQL Enterprise Server 2000/2005 on Windows Server 2003 to Cluster SQL Server R2 and standalone SQL Server R2 on Windows Server 2008 R2.
  • Worked on the migration from MySQL to SQL Server and Oracle to SQL Server.
  • Performed production activities, including project activities, involved in several cab meetings for production deployments. Monitoring of database size and disk space in Production, Staging & Development environments.
  • Configured Transactional Replication, Log Shipping and mirrioring.When we had 5000 user connections solved latching issues by creating multiple servers (Read - Only Servers) using replication.
  • Set up database backup and recovery strategies Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis. Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
  • Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts). Expertise in Security Issues such as creation and granting permissions on various Objects.
  • Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications both on SQL server.
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Maintained cluster servers to provide high availability and implemented Disaster Recovery (DR)
  • Set up database backup and recovery strategies Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
  • Configured Database mail, linked servers in SQL server 2005.Creation and scheduling of Maintenance plans/Backup and restore jobs. Maintained nightly refreshed jobs.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
  • Responsible for MS SQL Server 2000/2005, configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
  • Documented up gradation procedures from MySQL to SQL Server, Oracle to SQL Server all SQL related documentation.
  • Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems
  • Good Knowledge of using SSRS (SQL Server Reporting Services).
  • Performed 24/7 Production support and on Call duties.

Environment: MS SQL-Server 2000/2005, DTS, SQL Diagrams, Erwin, Windows 2003 Server, MS Access, ASP, Oracle 9i, MS Analysis Services, Diagnostic Manager, MS Reporting Services, HTML, SQL Light speed Backup Software, Windows Enterprise Server 2003, BizTalk Server 2004, IIS 6.0, .NET, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service.

Confidential, Fitchburg, MA

SQL Developer/SQL DBA

Responsibilities:

  • Learned and provide DBA support the department to which assigned.
  • Perform special projects as assigned or approved by the assigned department management staff/Professor.
  • Interact with team members to audit servers for adherence to licensing policies.
  • Update system and process documentation to reflect current state. Experienced with Windows Server operating systems. Experience with Unix or Linux operating system
  • Assist with daily monitoring and error investigation. Handling database objects with Enterprise Manager and Query Analyzer. Installation and configuration of Microsoft SQL Server Reporting Services.
  • Installation of SQL Server 2000/2005/2008 and upgrade, Migration of databases from SQL Server 7.0 to SQL Server 2005/2008.
  • Performed all aspects of database administration, including data modeling, backups and recovery.
  • Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
  • Configured SQL Mail on the Production, Test and Development Environments for Notification Services.
  • Work with development team in implementing business logic using T-SQL Triggers, Views, Stored procedures, and User Defined Functions for web applications
  • Handling database objects with Enterprise Manager and Query Analyzer. Installation and configuration of Microsoft SQL Server Reporting Services
  • Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server at acceptable levels.
  • Used SQL profiler to monitor the Server performance, debug T-SQL and slow running queries
  • Well organized, self-starter who eagerly approaches new challenges and looks for opportunity.

Environment: Windows 2000 Advanced Server/Server 2003, MS SQL Server2000/2005, TSQL, VERITAS Backup Exec Agent, ASP.NET.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Installing and configuring of SQL Server 2005/2000/7.0 on Windows 2000/NT OS/2003.Involved in writing scripts for the clients requirements for reporting purposes. Experience in upgrading databases from SQL Server 2000 to SQL Server 2005. Installation of MS SQL Enterprise servers on production, Test and Development boxes.
  • Participated in gathering Business Requirements and System Specification from users
  • Responsible for writing T-SQL code for creating cursor and handling the data validations and developed complex T-SQL code for the application. Transformed the complex business logic and calculations into coding.
  • Involved in creating SQL server Analysis Projects using MS SQL Server 2005. Created cubes and dimensions.
  • Implementing backups and restoring when necessary for the SQL databases.
  • Implemented calculations to aggregate physical measures defined the Browsing Prospective and Browsing Translations and responsible for Process Database Objects Security Role.
  • Developed DTS Packages to transfer the Data between SQL Server database and Files
  • Creation and management of database maintenance plan for various database consistency checks
  • Extensively used Joins and Sub Queries to simplify complex queries involving multiple tables
  • Developed indexed generic views to facilitate easy user interface implementation and enforce security on critical customer information.
  • Configured SQL Mail on the Production, Test and Development Environments for Notification Services.
  • Work with development team in implementing business logic using T-SQL Triggers, Views, Stored procedures, and User Defined Functions for web applications
  • Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server at acceptable levels.
  • Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).

Environment: Windows 2000 Advanced Server/Server 2003, MS SQL Server2000/2005, TSQL, VERITAS Backup Exec gent, ASP.NET, Windows 2000,2003, SQL Server 7.0/2000/2005 Enterprise, Crystal Reports, SQL Profiler, DTS, T-SQL

Hire Now