We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

2.00/5 (Submit Your Rating)

Palo Alto, CA

PROFESSIONAL SUMMARY:

  • 8+ years of experience in Database Administration using MS SQL Server 2016/ 2014/2012/2008 R2
  • Day - to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning as well as researching, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
  • Expert Level skills in providing 24x7 DBA Level 3 support in Production, QA and Development.
  • Performed and designed Data Center Migration, Disaster recovery Solutions for Entire Data center.
  • Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven.
  • Knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN an infrastructure.
  • Migration experience with multiple databases/servers from SQL 2000 to SQL 2005 and SQL 2005, SQL 2008R2 to SQL 2012, SQL 2012 to SQL 201
  • Design, Architect and Tune OLTP or OLAP requirements.
  • Exposure to z/OS mainframes to DB2 LUW migration
  • Experience in implementing replication, backup and recovery strategies, performance tuning and installing DB2 and extensive experience usin g DB2 LUW /UDB EE and DB2 LUW /UDB EEE on LINUX/UNIX platform
  • Experience and Knowledge on HA/DR like Replication/log shipping/Mirroring/Clustering.
  • Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012 especially considering memory limitations.
  • Experience in maintaining a large Team, Onsite/Off shore model.
  • Performance Tuning Application level for code, queries, Identify slow performing SQL objects and enhance for optimum database performance.
  • Automated DB2 for LUW maintenance with shell scripts
  • Conducted RCA for database incidents and problems.
  • Well Experienced in Performance Tuning (System level/Database Level/Query Level) and optimization.
  • Experience in working with DTS/SSIS (ETL) in SQL, 2000, 2005 and with SSRS 2005, 2008, 2012, 2014, 2016.
  • Extensive experience in SDLC in developing an application, with Installation, design, architecture, data flow, Maintenance and Operations of a system.
  • Thorough understanding of blocking/lock issues, Tempdb Optimization, Filegroup management
  • Experience of Export/Import Database Objects / Tables /data using DTS and SSIS packages.
  • Thorough understanding of tools like Perfmon, SQL Profiler, DTA, DB Artisan, LiteSpeed, SQL sentry etc.
  • Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
  • Thorough knowledge on SAN environments, RAID levels, VMware Environments.
  • Experience using Resource Governor and Policy Based Management system for maintenance.
  • Hands on experience with TFS and SharePoint.
  • Experience in working with VLDB databases up to 16TB, Managing Backups, Disk & Drive Space issues, managing indexes.

TECHNICAL SKILLS:

Programming Languages: T-SQL, PL/SQL, Unix.

RDBMS: MS SQL Server 2016,2014,2012/2008R 2/2008/2005/2000 /7.0, SYBASE,MYSQL,ORACLE

Web Tools: Internet Information Server (IIS), FTP, TCP/IP, SMTP, LAN, MS-Outlook Express.

Operating Systems: Windows 2008, 2003 Enterprise Server

Database Tools: SSMS, BIDS, DTA, SQL Profiler, DTS, DTSRUN, MS Visio, Import & Export (DTS), DTSXChange, SSRS, SSAS, SSIS, Erwin, LiteSpeed, Crystal Reports 10.0,Share Point, SQLCMDUtility Tools: MS Office, MS Project, Visual Source Safe 6.0, (SCOM), Visio 2007.

PROFESSIONAL EXPERIENCE:

Confidential, Palo Alto CA

Sr. SQL SERVER DBA

Responsibilities:

  • Supported 300+ SQL 2012/2008/2005 databases in clustering environment (A/P & A/A) including database mirroring/Log shipping on critical databases having 5+ TB in size.
  • Performed successful Migrations SQL 2008 to SQL 2012, SQL 2012 to SQL 2014, SQL 2014 to SQL2016 and Stand alone to cluster server.
  • Managed successful migration of critical production and contingency servers with no impact to business.
  • Optimized Data center migration & consolidation by employing various migration strategies; such as virtualization, seed swing migration, fork-lift migration and server consolidation.
  • Implement Disaster Recovery drills and Document.
  • Design, setup and capacity planning for Datamart. Teamed with Application team in building interfaces and Dataflow.
  • Implemented and designed SSAS server, cubes, automated backup and restore using PowerShell and XMLA scripts.
  • Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
  • Automate Failover in Log Shipping Databases for DR.
  • Deploying SSIS packages in production File System to implement business logics and troubleshoot them when needed.
  • Automated daily database refreshes using Power shell from production to staging and on-demand refreshes from production to test environments, involving SQL versions2016, 2014/2012/2008.
  • Create and Develop Admin Reports of SQL inventory, Objects modified Logins and Error reports.
  • Implemented data partitioning to improve the performance of large table reduces contention and increases availability of data.
  • Implement and test Database Backup to a Data duplexing device and confirm RPO and RTO to implement retention of backup and storage.
  • Involved in Change Management, Problem management, process management before implementing database changes in production and development activities.
  • Implemented backup and restore strategy for SQL, SSAS production and DR environments using PowerShell and T-SQL.
  • Performance tune application interfaces, database queries, and legacy systems using, Performance monitor SQL Profiler, DMVs, SQL Query Analyzer and Index tuning wizards.

Environment: MS SQL Server 2016, 2014/2012/2008 R 2/2008/2005/2000, Windows Server 2008 R 2/2008/2003/2000, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), MS SQL Server 2008/2005, OLAP Tools, SQL, PL/SQL.

Confidential, Union, NJ

SQL Server DBA/ Developer

Responsibilities:

  • Installing and maintaining and SQL server 2005/2008 R2 Servers. Productions support 24/7 for more than 400 servers.
  • Performance Tuning of SQL Server 2008R2 environment with UAT load testing for capacity and performance analysis. New Application Snapshot deployment.
  • Responsible for supporting over 150 SQL instances which include SQL R2 2012.
  • Migrated Databases from SQL Server 2005 to SQL Server 2008R2 2012 in Production and test Environments.
  • Installed SQL Server 2012 Cluster and configured Always On availability group set up on Windows Server 2008R2 in Development production environments.
  • Configured Monitored Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery.
  • Support and troubleshooting for Transactional replication.
  • Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business Requirement Document).
  • Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.
  • Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
  • Creating databases and logins and users with permissions in SQL server .
  • Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
  • Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
  • Backup and Recovery of Production Databases and Tuning them for better Performance.
  • Deploying and Troubleshooting SSIS packages.
  • Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
  • Creating new Databases and Migrated SQL Server 2005 databases to SQL server 2008R2 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
  • Moved databases from SQL Server to SQL Server 2000.
  • Created Linked servers for distributed queries.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
  • Configured database mail to inform corresponding DBA basis on each Job Status.
  • Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
  • Monitored the Performance of the SQL Server by using Performance monitor, SQL Profiler, Performance Analysis and Spotlight.
  • Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.
  • Administered, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.

Environment: SQL Server 2005/2008R2, Windows NT/2008R2/2008/2003, IBM Lombardi BPM 7.5,T-SQL, SSIS, and SSRS, ETL.

Confidential, Plano, TX

SQL SERVER DBA

Responsibilities:

  • As a Production support DBA responsible for managing production, development and QA environments.
  • Managed multiple instances of SQL Server in Virtual and Physical environments with 32 64 bit environments.
  • Managed Production environments and participated in on call 24 7 support.
  • Did heavy duty Migration Upgrades from lower version of SQL Server to SQL Server 2008 R2.
  • Installed configured SQL Server in Virtual Environments using VMWare.
  • Installed SQL Server 2008 R2 2008 and SQL Server 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.
  • Exclusive Knowledge of Database security including creation of roles login user accounts and having good knowledge of authentication modes, types of roles.
  • Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL .
  • Implemented replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for transactional, merge and snapshot replication
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
  • Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle) and also Created Data Flows for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
  • Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
  • Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load.
  • Created the standard documents for Disaster recovery testing and implemented them.
  • Experienced with database sizing and capacity planning for production servers.
  • Created the backup schedule for production, test and development servers.
  • Worked with developers to do the database schema changes and database restore requests.
  • Involved in restore operations to refresh the data from production to test servers.
  • Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server, Windows Server 2008 R, Virtualization, SSIS, SSRS, SSAS, DTS, T-SQL, Clustering, Mirroring, Log Shipping, Replication.

Confidential, Atlantic City, NJ

Sr. SQL Server DBA/ Developer

Responsibilities:

  • Installed recommended service packs and security patches on production, test and development servers.
  • Designed and worked with Different RDBMS and applications collecting customers information of all BU’s into a Database and generated a Report on Customer’s overall Expenditure and Business to Cargill Agriculture business.
  • Created Linked Server to Oracle 11 to open query for SSRS.
  • Set up data Replication from Sybase ASE 12 and Sybase ASE 15 to SQL Server Dev and Production systems.
  • Performance Tuning to increase the speed and performance of CargillAg.com tuning hardware and software requirements.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS
  • Upgraded Test and Production databases from SQL 2005 to SQL 2008R2.
  • In SQL 2008R2 set up Database Partitioning to improve query performance.
  • Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
  • Suggested and modified code and schema changes for database objects and scripts.
  • Performed a Security Audit for all SQL and Sybase servers.
  • Extensive experience using Data Mining tools Microsoft Analysis Services (SSAS).
  • Utilized Resource Governor to handle two applications on the Server.
  • Supported and learned a very complicated Replication system between hundreds of Sybase and SQL Servers. Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler, Perfmon and Best Practice Analyzer.
  • Good experience in working with high volume of transactions for OLTP & OLAP applications.
  • ETL tool Running 24/7 transferring data between the SQL Servers.
  • Experience in Shell scripting (Perl, power shell).
  • Used Putty to connect and work with UNIX servers hosting Sybase databases.
  • Worked on UNIX operating system hosting Sybase and successfully applying patches and deploys.
  • Expertise in Using Third party tools like Dbartisan, sqlDeveloper, Sybase central to Oracle, Sybase servers .Worked with TOAD and LiteSpeed for Backup and restore.
  • Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis
  • Monitoring and Troubleshooting jobs, Backups and Restore database policies.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
  • Thorough understanding of standard SOP’s, SLA’s and change control management process.
  • Generating Reports as per the requirement using SSRS 2005/2008.
  • Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.

Environment: SQL Server 2000/2005/2008, Sybase ASE 12,15 .Sybase Replication 15 MS Access, Windows NT/2008/2003 Advanced Server, T-SQL, SSIS, and SSRS, PLSQL,UNIX,AIX servers.

Confidential

SQL Server DBA

Responsibilities:

  • Providing 24x7 supports to Production, QA and Development servers.
  • Involved in installations, upgrades, patches and fixes.
  • Worked with Terabytes of Data with over 500 databases.
  • Successfully migrated the data from SQL Server 2000 to SQL Server 2005/2008.
  • Worked on data compression features of SQL 2008 R2.
  • Monitoring and Troubleshooting jobs, Backups and Restore database policies.
  • Worked on high availability SQL solutions, including Log shipping, Replication and SQL Server clustering.
  • MySQL database performance optimization.
  • Worked with Application manager to accommodate data to MYSQL.
  • Working experience on Active -Passive and Active -Active Clustering model.
  • Successfully migrated SQL 2005 mirror model to SQL 2008 cluster model.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
  • Work with project teams for Migrating data from MS Access to SQL Server 2005/2008.
  • Writing DTS (SQL 2K) as well as SSIS (SQL 2K5) packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for the Data Migration team and also upgraded DTS packages to SSIS packages.
  • Generating Reports as per the requirement using SSRS 2005/2008.
  • Configuring and Setting up BMC Patrol alerts in Production, Preview, QA & DR, Test environment.
  • Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
  • Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
  • Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server error logs.
  • Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.
  • Designing Logical and Physical Data Model with Erwin tools.
  • Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
  • Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Environment: SQL Server 2000/2005/2008, MS Access, Windows NT/2000/2003 Advanced Server, T-SQL, SSIS, and SSRS.

We'd love your feedback!