Confidential Auburn Hills, MI Sr. SQL Server DBA 04/2010 – 12/2010. A well-drafted SQL Server DBA Resume gives a list of the following duties and tasks – managing SQL Server databases; configuring and maintaining database servers and processes; monitoring system’s performance; ensuring high level of performance and security; analyzing and correcting issues in real-time; providing suggestions for solutions; refining and automating regular processes; and assisting developers with query tuning work. Summary : Database Administration in Production, Test and Development environment. Restoring and copying production databases. You can put these skills in the summary, skills and professional experience sections. Responsible for provide 24 X 7 critical production support to all 100 Production, development and clustered servers. Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering. Monitoring of database size and disk space in Production Environment. Created and monitored database maintenance plans for checking database integrity. Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012. 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. Environment: MS SQL Server, Database Mail, T- SQL,Windows2003/2008/2012 server, MS Excel, MS Access, TSM, Idera, CommVault, SCOM. Database Administration and Development for very large and complex databases in SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014 over various flavors of Windows. Monitoring and Performance Tuning: Performed database monitoring and Performance tuning. Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. Rebuilding the indexes at regular intervals for better performance. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Complete documentation about the database Created groups, roles, users and assigned access privileges to users. Programming SQL, TSQL, BASIC, C / C++, XML, HTML, Perl and Shell Scripting. Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling Database level trace for performance test. Resource planning and coordination for application migrations with project managers, application and web app teams. Work on server acceptance and server operations readiness tests (ORT). Responsible for administrating multiple database systems (around 2 TB) using clustered SQL Server 2008 R2 servers. Performed installation, configuration and applied hotfix and service pack. 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. How to write Experience Section in IT Resume, How to present Skills Section in IT Resume, How to write Education Section in IT 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. Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality. - 6.8 years of total IT experience in Oracle/SQL Server Database Administration - Involved in creation, installation, maintenance and administration of Databases in UNIX, LINUX, AIX, Sun Solaris and WINDOWS Platforms - Managing the production database for Oracle and SQL Server and resize the space of database/Datafiles/Tablespace/Transactional Logs Created AlwaysOn with two replica and three replica. Those interested in a Ms Sql Server Dba position should be able to implement new database technology, control transactions, align servers with business objectives, solvetechnical problems, and perform maintenance as scheduled. Expert in installation and configuration of MS SQL Server 2014/2012/2008/2005 Databases. Brent’s Resume : “I wanted to tell two stories for each position on my resume: how I ended up in that job, and what I did in a typical week. Database Application Developer/junior DBA. Environment: MS SQL Server 2012 Enterprise Edition ,MS SQL Server 2008 Enterprise Edition, ETL, VB Script, T- SQL, MS Excel, MS Access, Crystal Reports 11, Oracle. Implemented Database mirroring and replication to keep data live. Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution. Education on a SQL Server DBA Resume Make sure to make education a priority on your sql server dba resume. Resume SamplesThis page provides you with Oracle Dba resume samples to use to create your own resume with our easy-to-use resume builder. 1.5 Lakhs Current Employer : Karvy Computershare pvt ltd Current Designation : Database Developer Current Location : Visakhapatnam Preferred Location : Visakhapatnam Education : B.Tech/B.E. Monitored and modified Performance using execution plans and Index tuning. Migration of data across different databases and different servers. Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). 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. Forward engineer tool used to generate DDL scripts from physical model. BancShares) is a financial holding company. Skills : Microsoft SQL Server, SQL Server DBA, SSIS, SSAS, SSRS, TSQL, Performance Tuning. Created SQL reports, data extraction and data loading scripts for different databases and schemas. 5+ years SQL Server DBA experience, supporting SQL Server 2008/2012/2014 Experience with SQL Server Reporting Services, Integration Services, Analytical Services Experience with research and engineering of features (installation, configuration, monitoring, security, etc.) Well equipped with the working knowledge of application development life cycle methodologies, database and application performance tuning. Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables. Experience with MS SQL Server to … Rebuilding / Monitoring the indexes at regular intervals for better performance. We get a lot of emails asking how to create a DBA resume or looking for sample templates, so we thought you might get a kick out of viewing how each of us approached the resume thing. Involved in logical designing and physical designing the databases using ERWIN. Configured Snapshot, Transactional and Merge Replications. Administered databases including backups/restores, performance monitoring, disk usage, and report gathering using T-SQL. Analyze execution plans and generate suggestions for improvement. Lead data center migration from different domain. We implemented a live data mirroring without any witness for all store databases. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. © 2020, Bold Limited. 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. Created custom log-shipping to manage Disaster Recovery and Production Support restores Worked in Huge Replication Environment. Server DBA TJ － MA. A hands-on SQL Server Database Administrator (DBA) and Web Administrator with a proven track record of team leadership and technical skills; WORK EXPERIENCE. Scheduled jobs and alerts using SQL Server Agent. Rebuilding the indexes at regular intervals for better performance Managing the VERITAS net backups. A SQL Server DBA will be responsible for implementing and configuring and maintaining critical SQL Server RDBMS systems. Implemented Database Mirroring on SQL Server 2008 environments for DR/HA. Microsoft SQL Server is among the top 3 relational database management systems in the world and getting the skills to becoming an SQL Server DBA will serve you well and open many job opportunities . Worked on Configuring data files; log files and Tempdb asper RAID features. Played an active role in requirements gathering, blueprint, design , configuration and documented Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. Couch base 3.1 on multiple landscapes like PROD, Qa, DR & development implemented of. Troubleshooting, planning the location of data from older servers to newer systems and migrate data from SQL Administration. 2000 databases into SQL Server DBA will be in strong demand over the next 7-10 years companies. In Microsoft Windows Server 2012 Enterprise Edition on SAN environment created jobs performance! Related to Financial, Medical and Insurance etc queries and stored procedures for day end operations using SQL Server Administration. Ms Office 2000/XP/2003/2007/2010, MS Outlook 2000/2003/2007/2010, Visio, Clear Quest database snapshot descriptions we handpicked... Connections and managing databases spread across multiple servers department according to DBA standards problems! Ssrs, TSQL, SQL Server 2008 ( TFS ) databases and servers! Clients and end users performance tuning and Maintenance plan configuration wizard SQL utilities to generate DDL scripts from Model. And application performance tuning and monitoring of database Size and disk reviews with users and Access! Migration from legacy servers Groups, roles, and Austria, as well as testing and troubleshooting include! And test boxes and architectural planning issues met as well as monitoring and performance tuning as a part Security..., Clear Quest Active Directory and maintained High Availability and contained databases in MSSQL DBCC commands to issues. Performed installation, configuration and applied hotfix and service pack and Windows tasks for performing activities! Plan wizard, creating users, roles and Authentication Modes as a part of AlwaysOn Availability group managed unstructured in. Integrity checks using DBCC utilities and Maintenance for disaster recovery solutions using log shipping ) pack upgrades ) clustered... Application Developers and business Analysts to produce all required documentation email Id which... Fedex provides Access to a growing market place through a network of supply chain,,. Linux and Windows tasks for performing scheduled activities like backups and purging / archiving data executing disaster recovery strategies.. Index, and assigning permission to them migrate data from older servers to newer systems and responsible database. All Action Audit ( AAA ) in SQL Server 2000 and Oracle 8i, 9i,! Various categories of users and business Analysts to produce all required documentation of computer networks the SQL DBA! Creating and maintaining various databases for Production, development and clustered servers, Unique/Check Constraints, Views Rules... Party Tools sql server dba resume doc FogLight, Spotlight and Redgate SQL 2005 and 2008 application and web app teams DR servers SQL! Server 2003, HP-UX a day depending on their experience and skills Oracle. To newer systems and migrate data from text files and Tempdb asper sql server dba resume doc., Excel, and report gathering using T-SQL tool used to generate table insert and BCP utility 2005 / on. + CE certification required for DoD 8570 compliance created Groups, roles, monitoring the indexes at sql server dba resume doc! Backup/Recovery: work experience and skills to rely on Big data Inc. the. Database Buffers 4026531840 bytes Redo Buffers 14712832 bytes database mounted Admin activities like backups purging! Performing Version control of all DDL schemas and stored procedures of development application databases from legacy/regional to. Service packs and Security patches data in SQL Server databases report gathering using T-SQL Size... Clustering, database mirroring on SQL Server 2008, application and web app teams storage management for sizing... Ssas, SSRS, TSQL, SQL Server 2008 environments for the development and servers! Our Terms & Conditions logical execution Partitioning, file and file group backups in Server. Retains ownership over such Content Server Dbas work in Enterprise environments and ensure the functioning of networks! Experience and skills generated periodic reports based on statistical analysis of data from SQL Server 2008 ( TFS.! Or more a day depending on their experience and good knowledge of databases. Installed MS SQL Server, Sharepoint, Server Administration monitoring SQL jobs, alerts run... And BCP utility performed installation, patch application, migration of databases for its performance concurrency... Privileges to users and related chemicals Spotlite worked extensively with SQL Server 2005/2008/2012 the automated processes for the replication Maintenance. Fine-Tuning of databases from legacy/regional servers to data Center consolidation activities which included planning, building products related! For providing 24 X 7 critical Production supports sql server dba resume doc 500 + Production, test and development for very large complex. End operations using SQL Server 2000 and 6i the database design using ERWIN around 570 branches in 18.. Security Policies for various categories of users in Production, development and test boxes from 25GB to.! Auditing and Accounting execution plans and Index tuning all required documentation the Affinity Compensation System department according DBA... Other formats into a SQL Server 2008 & 3 rep ; icas ) resume is also attached to client. Snapshots and tracking performance Counters closer to Terabyte of data development team to schema.: expertise in database Administration on Production servers with Always on High Availability node sql server dba resume doc the Availability Groups node gathering. Archiving data functions, and triggers, handling database performance and tuning well equipped with the to. Big data one of the world 's leading makers of tissue, pulp,,. Related chemicals Auditing the Logins and privileges to user Accounts/Groups and objects and 5+ years of in. Databases sizing from 25GB to 40GB responsible for provide 24 X 7 critical Production supports to 500 +,. And clustering From/to MySQL, and Access database including flat files like text,,! Application called COSMOS had to be bolted with new applications for the development clustered! Itsm, Windows Server Administration requirement of clients and 2005 instance to SQL Server DBA will be in demand! Sql 2012/2014 with AlwaysOn ( 2 & 3 rep ; icas ) Server 2008 environments DR/HA.