SQL Server DBA Resume
Objective : Associate has more than 10 years of experience in the Information Technology with Certificates like Querying Microsoft SQL Server 2012 (MCSA), Microsoft Technology Specialist Certification.
Skills : Understand Both the Business Needs and Technology Landscape.
Description :
- Implemented daily reports to highlight Backup failures, Disk space issues and Job failures.
- Implemented couple of projects for SAP which involved in designing landscape for database servers.
- Installed MSSQL 2012 & 2014 sql servers with Always on Feature and Geoclustering capabilities.
- Involved in troubleshooting and resolving the performance issues in SAP & other application database servers.
- Installed couch base 3.1 on multiple landscapes like Prod, Qa, DR & Development.
- Upgraded couch base from 2.0 to 3.0.3 and 3.1 versions.
- Worked in analyzing the couch base buckets capacity planning & XDCR, FRAGMENTAION.
- Migrated spotlight from one server to another server and upgraded it from 10.0 to 10.5.
Experience
2-5 Years
Level
Executive
Education
IT Technology
MS SQL Server DBA Resume
Objective : Hands on experienced in MS SQL Server Installations, Performance Tuning, Backup and Recovery, Query Optimization, SQL Clustering and Replications and Security of database Servers. Worked independently as well as in team-oriented environments. Establishing guidelines for a defined database architecture and database builds. Experience in supporting huge SQL Server databases trouble-shooting problems.
Skills : Microsoft SSIS, Oracle, MS SQL Server, Stored Procedures and Triggers, Microsoft SSRS, MS Access, Microsoft SSAS, ETL, Transact SQL, PL/SQL, Data warehousing tools, Visual Studio.
Description :
- Responsible for Database support, troubleshooting, planning, and migration.
- Resource planning and coordination for application migrations with project managers, application and web app teams.
- Monitoring of database size and disk space in Production Environment.
- Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
- Security and architectural planning issues met as well as testing and training.
- Cluster Servers Failover testing and troubleshooting and resolution as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
- Configured Snapshot, Transactional and Merge Replications.
Experience
2-5 Years
Level
Junior
Education
BSc. In Electronics
SQL Server DBA/Developer Resume
Summary : Over 14 years of experience as Sql Server DBA and total of 25 years experience in the IT industry.e/ ion Extremely high skill in trouble shooting performance problem Excellent team player who can work wih diverse team and give excellent results Expert level knowledge in Sql Server Database Administration for both sql 2005/sql.
Skills : Microsoft SQL Server, SQL Server DBA, SSIS, SSAS, SSRS, TSQL, Performance Tuning.
Description :
- SQL Server Database Administration Responsibilities: DB Migration, code deployments, backups and recovery, DB upgrade, performance tuning and optimization, troubleshooting and error resolution, DB and Logins creation and granting privileges, OLTP, OLAP.
- Worked extensively with SQL Litespeed and Spotlite Worked extensively with SQL database security.
- Monitoring and tuning of SQL Server versions 2005 & 2008, 2008R2, 2012, and 2014 Managed Security using SQL Logins, Roles and Security Modes for various users.
- Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
- Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
- Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
- Analyze execution plans and generate suggestions for improvement.
Experience
7-10 Years
Level
Management
Education
BE In Economics
Junior SQL Server DBA Resume
Summary : Experience and good Knowledge about the newly added features like Always ON High Availability and contained databases in MSSQL. Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering.
Skills : Microsoft Office.
Description :
- Monitoring and Performance Tuning: Performed database monitoring and Performance tuning.
- Monitor Servers activity, and worked with clients to solve different problems.
- Performed index and statistics management.
- Performed database integrity checks using DBCC utilities and maintenance plan configuration wizard.
- Implemented troubleshooting of SQL Server performance issues using SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA).
- Export & Import data: From/to MySQL, and Access Database including flat files like text, excel, and to SQL Server 2008/2012.
- Backup/Recovery: Work experience and strong knowledge in disaster recovery.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies.
Experience
7-10 Years
Level
Management
Education
International Business.
Lead SQL Server DBA Resume
Summary : Around 8 years into SQL Server Administration, driving business excellence through Design, Development, Analysis, Implementation and Maintenance of diverse database systems in various business domains like Banking & Finance, Insurance, and Pharma etc. Database Administration and Development for very large and complex databases in SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014 over various flavors of Windows.
Skills : TSQL, SQL Server, SSIS, SSRS, Windows, Networking, Active Directory.
Description :
- Responsible for providing 24 X 7 critical production supports to 500 + Production, development and clustered servers.
- Implemented and maintained high availability systems (clustering, database mirroring, log shipping).
- Responsible for administrating multiple database systems (around 2 TB) using clustered SQL Server 2008 R2 servers.
- Support for software used by business folks that conduct their daily business of Sales, Auditing and Accounting.
- Support production systems and migrate data from older servers to newer systems and responsible for Administrating the releases as they come available.
- Create, deploy, configure and monitor complex ETL/SSIS packages Wrote stored procedures to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization.
- Daily Admin activities like controlling the user privileges, roles, monitoring the security and Audit issues.
- Implemented many automated task which been historically done manually using PowerShell, T-sql or Command line utilities.
Experience
7-10 Years
Level
Consultant
Education
Computer Science
Senior SQL Server DBA Resume
Summary : Over 7+ years experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Servers 2012, 2008 R2, 2008, 2005 & 2000 in various domains like Finance, Manufacturing. Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database design and Query optimization. Good knowledge of Relational Database Management Systems (RDBMS).
Skills : Operating Systems Windows, Unix, Linux. Databases SQLSERVER.
Description :
- Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
- Implemented Failover clustering for Active/Active and Active/Passive for HA.
- Managed SQL Server Clusters in a SAN environment.
- Implemented Database Mirroring on SQL Server 2008 environments for DR/HA.
- Configured and maintained Log shipping architecture to provide a backup server solution for 4 environments in a DR.
- Managed and Administered databases in SCOM.
- Managed all Publisher, Distributor and Subscriber database environments for the replication.
Experience
7-10 Years
Level
Senior
Education
Software Engineering
SQL Server DBA II Resume
Summary : Database Administration in Production, Test and Development environment. 8+ years of experience in Database Administration and Development for very large and complex databases related to Financial, Medical and Insurance etc.
Skills : SQL Server 2012, 2008R2, 2008, 2005, T-SQL, Log Shipping, SSIS packages, SSRS reports, PowerShell, .NET, C#,.
Description :
- Responsibilities: Involved in designing of Conceptual Logical Model and Physical Model.
- Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
- Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
- Created SQL reports, data extraction and data loading scripts for different databases and schemas.
- Wrote Transact SQL utilities to generate table insert and update statements.
- Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
- Involved in performance tuning and monitoring of T-SQL blocks.
- Involved in Data modeling to develop the database design using Erwin.
Experience
7-10 Years
Level
Management
Education
IT Technology
SQL Server DBA/Database Developer Resume
Summary : Over 5 years of experience in production, test and development environments for very large and complex databases in SQL Server r2,2012 and 2014 Experienced in Installation, Configuration Upgrading and Maintaining of SQL server 2008 r2 and 2012 on a standalone. Performed Upgrade and Migration of SQL Server from 2005 to 2008 r2 Experienced in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for I/O, network, CPU utilization and Virtual Machine.
Skills : Trust, Honesty and Integrity.
Description :
- Worked as development and production support DBA for SQL Server 2012, 2008 R2, 2005 and 2000 of up to 3 TB size database both OLTP and data warehouse.
- Performed installation, configuration and applied hotfix and service pack.
- Lead data center migration from different domain.
- Upgraded several SQL server 2000 and 2005 instance to SQL Server 2008 R2 and SQL 208R2 to SQL 2012 instance.
- Developed maintenance plan for backup (SQL native tool, Red Gate and DD Boost), index rebuild and cleanup task for several databases.
- Created backup policy according to business need.
- Configured database mail, setup alert, created linked server.
Experience
7-10 Years
Level
Management
Education
Computer Science
SQL Server DBA III Resume
Summary : Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
Skills : Experience to Know When to be Firm and When to be Flexible.
Description :
- Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
- Installed and administered Four-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
- Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
- Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
- Experience in Using DMVs, Performance tuning, Mirroring, database snapshots and tracking Performance Counters.
- Rebuilding / Monitoring the indexes at regular intervals for better performance.
- Recovering the databases from backup in disasters.
- Implementing Point-In-Time Recovery solutions.
Experience
7-10 Years
Level
Management
Education
Associate's In Science
SQL Server DBA I Resume
Summary : Extensive Experience in Installation, Configuration and Maintenance of SQL Server Database. Migrated SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008. Have Experience working with Data Compression techniques like Row Level and Page Level Compression and Database backup Compression in SQL 2005 and 2008.
Skills : Microsoft SQL Server, Sharepoint, Server Administration.
Description :
- Responsibilities: Database Administrator, Database Programming.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Rebuilding the indexes at regular intervals for better performance Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Monitored and modified Performance using execution plans and Index tuning.
- Rebuilding the indexes at regular intervals for better performance.
- Deploying new code base release to UAT and Production Environments.
- Perform SQL Server service pack and Windows Service pack upgrades.
Experience
7-10 Years
Level
Management
Education
CS
SQL Server DBA Lead Resume
Headline : Experience in Installation, Configuration, Maintenance and Administration of SQL Server, Experience in upgrading SQL Server from version 2005 to good experience with partitioned schemas, partitioned tables and indexes, creating file groups using SQL Server 2008.
Skills : Productive Under Pressure, SQL Servers go down.
Description :
- Creating and maintaining various databases for Production, Development, and Testing using SQL Server 2005.
- Installing SQL Server 2005 / 08 on the server and client machines, providing connections and managing databases.
- Planning and scheduling backups and developing recovery procedures.
- Migration of data across different databases and different servers.
- Creating procedures, functions, and triggers, handling database performance and tuning.
- SQL Server Installation, patch application, migration of databases.
- Creation of new databases, planning the location of data, index, and Transaction log files on disks.
Experience
5-7 Years
Level
Consultant
Education
Information Technology
SQL Server DBA Resume
Summary : Over 6+ years of Experience as a SQL Server DBA in implementing and supporting Microsoft Enterprise SQL databases in complex, multi-national, Manufacturing, Oil & Gas, Product and Technology enterprises Received star award for outstanding dedication and commitment in demonstrating excellent support capabilities for a Fortune 100 and one of the largest technology distribution company. Experience in Data Center consolidation activities which included planning, building new SQL servers on cluster environment, migrating application databases from legacy servers.
Skills : SQL Server Administration, TFS Administration, ITSM, Windows Server Administration.
Description :
- Worked at client location in Singapore for 13 months for Data Center consolidation project.
- Experience in planning, building new SQL servers on standalone and cluster environments.
- Worked closely with Security team on implementing firewall ports, strict access controls for the SQL servers.
- Worked closely with Network, Server and Storage teams to implement an extensive and efficient environment in the data center.
- Installation and Configuration of MS SQL Server 2000/2005/2008/2012 Database Servers.
- Troubleshoot hardware bottleneck, system issues and proactively monitoring the performance of SQL Server databases.
- Work with application teams on migration of application databases from legacy/regional servers to Data Center.
- Work on server acceptance and server operations readiness tests (ORT).
Experience
7-10 Years
Level
Consultant
Education
Bachelor Of Engineering
