- Featured in:
-
More SQL Server DBA Resumes
Use these SQL Server DBA samples as a guideline or visit our extensive library of customizable resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
SQL Server DBA Resume Samples
No results found
0-5 years of experience
Responsible for providing database administration of SQL Server databases and mentoring less experienced adminstrators.
- Provided strategic direction for the database team and functioned as the technical/project leader on projects.
- Managed and administered 2800+ database in 105 instances. Initiated a project to consolidate servers and to remove old/unused databases. Reduced the number of databases to under 900 on 56 instances.
- Installed and configured a SQL 2012 clustered environment with availability groups.
- Installed and configured a SQL 2008 clustered test environment.
- Configured and supported replication and log shipping in both SQL 2008 and 2012.
- Documented processes for installations, clustering, availability group setup, and patching.
0-5 years of experience
Scripted, scheduled, and monitored different types of database backups and refreshes in use, including streaming backups and use of LUN mounts in SnapManager.
- Used Quest Spotlight and Confio Ignite monitoring tools to assess various aspects of system performance on numerous SQL Server instances.
- Used Sagent ETL applications to create base views and metaviews, and automate ETL processes from DB2 source environments to SQL Server destinations.
- Supervised code review of scripts and SSIS packages (2005, 2008) or DTS packages (2000) with developers. Advised developers in code optimization.
- Approved and ran scripts for Quality Assurance and Production releases.
- Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.
0-5 years of experience
Managed five SQL Server instances for the neuroscience department, developed and maintained SQL Server based applications.
- Implemented SQL Server based solution to consolidate dozens of scientific data collection and reporting applications.
- Collaborated with faculty member, scientist and staff to design data intensive applications to capture, organize, analyze and report on data collected from scientific experiments and external sources.
- Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
- Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done.
- Safeguarding data by instilling backup, managing user access and securing databases.
0-5 years of experience
Designed an SQL Server Database for IRS Disaster recovery. Modeled the Logical database and the major entities and relationships. Developed the physical database using SQL Server and Visio Diagrams in cooperation with the IRS team members.
- Created a centralized Data Warehouse from over 30 data sources for Business Impact Analysis.
- Presented Database and GUI components to IRS staff on a weekly basis while in development.
- Developed load procedures using SQL and other procedures to keep the Database current. Presented to management on a weekly basis the progress and issues regarding their data.
- Participated and was a key contributor to the GUI development as well as designed the overall work process, replacing the manual process currently being used.
- Provided IRS Team with a test plan and test and training in maintaining the SQL Server Database.
0-5 years of experience
Created an application to keep a structured record of training data using ASP.Net and VB.Net and SQL Server 2005.
- Created an application for Sales department that helped a salesperson to associate with it, its SalesPerson IDs and ProfitCenter Ids to finally burst a report. It was also designed using ASP.Net, VB.Net and SQL Server 2005.
- Responsible for installation and configuration of sql server 2005.
- Experience in creating database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.
- Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery.
- Experience with T-SQL (in writing procedures, triggers and functions)
0-5 years of experience
Performed database analysis, data modeling and database administration, data mining and data warehousing/BI.
- Maintained SQL Server Database; ensured accuracy of information and automated numerous functions.
- Fine tuning of database objects and server to ensure efficient data retrieval.
- Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.
- Designed and implemented incremental and full backup policies and procedures.
- Created and implemented database design solutions in collaboration with programming team.
- Developed user defined functions and triggers to implement the requirements of the business.
- Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
- Used database consistency checks using DBCC utilities.
0-5 years of experience
Designed database and implemented multiple systems using MS SQL Server. Responsible for MS SQL Server configuration, tuning and providing 24×7 dedicated support to all Production, development and clustered servers.
- Regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot using SEM (SQL Enterprise Manager). Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2003 Server.
- Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as requirement on SQL Server Environments.
- Assisted users by installing Sybase client on their PC’s, provided database access by adding their logins, creating roles, granting privileges, unlocked accounts, reset passwords.
- Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export.
- Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
- Improved performance, reliability, security and scalability by improving internal processes and make recommendations on new storage hardware.
- Controlled and monitored user access to the database, backed up and recovered the database, maintained system security and monitored/optimized database performance for Data warehouse and OLTP applications.
- Used Erwin for Data modeling, designing and building relational databases.
0-5 years of experience
Install, configure, upgrade, and maintain database instances. Create various database objects, and create users with appropriate roles and levels of security.
- Achieved 99.9% uptime on all SQL Servers
- Recommend and implement database security policies that are consistent with security guidelines and best practices.
- Provide DBA support and technical expertise for multiple applications in development, test, QA and production – SQL Server 2005, 2008, and 2012 environments.
- Develop strategies in migration SQL 2005 servers to 2008 SQL Servers.
- Worked on building and supporting highly available clusters.
- Provide 24/7 support as sole DBA
- Managed SQL Server -based Applications
- Experienced in using SQL Server Profiler and SQL Server Agent.
0-5 years of experience
Responsible for installing, configuring and maintaining SQL Server instances for Sungard’s clients.
- Assisted with capacity planning, implementing and documenting SQL Database migration for Relius custom
- Created SQL Server audits and policies to monitor activity on SQL databases to ensure databases were in compliance, and met the Service Level requirements of our clients.
- Scheduled full, differential, and transactional log backups for user created databases in production environments.
- Responsible for setting up security, and providing user access to SQL Server instances and objects.
- Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV’s.
- Assisted our development team with writing effective T-SQL stored procedures and views.
- Responsible for setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.
- Configured, and supported and Log Shipping and Database Mirroring strategies to support our client’s High
- Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments.
- Participated in on-call schedule to respond to SQL Server alerts and potential production database issues.
0-5 years of experience
24×7 Production Database support and administration
- Installed, configured and managed 11gr1, 11gr2 RAC databases
- Implemented Data guard successfully between 11g RAC databases using RMAN active duplication and backup based duplication.
- Installed, configured and managed SQL Server 2008, 2008R2 cluster databases
- Analyzed and worked with development teams like Informatica, Microstrategy, Sterling, JDA etc, to improve database performance using various tools in Oracle and SQL Server like Grid Control, SQL Trace, AWR reports, statspack, SQL profiler etc.
- Implemented Oracle Streams between 11g RAC databases.
- Implemented SQL Server Replication in a clustered environment.
- Developed and implemented data security guidelines.
- Installed and configured Oracle enterprise manager cloud control 12c for centralized monitoring and administration.
0-5 years of experience
Involved in the gathering of user requirements, user group meetings, defining report specifications and design of specification documents based on user requirements.
- Involved in the design and development of a web-based user interface application using Visual Basic 6.0, ASP 3.0, COM, HTML, SQL Server 2000, VBScript, MS Access in a Multi tier architecture based environment.
- Involved in the design and development of COM DLL’s.
- Used ADO connectivity to connect to database.
- Implemented business rules in functions and procedures of Visual Basic 6.0 and stored procedures
- Designed and developed functions in ASP 3.0.
- Designed and developed database objects like Tables, Views, Stored Procedures, Functions.
- Involved in performance tuning and trouble shooting of sql queries.
- Involved in the functional testing and validation of the user interface application.
- Designed and developed adhoc SQL queries based on user requirements.
0-5 years of experience
- Worked as Jr.SQL DBA\Developer, additionally completed academic project in this company.
- Installation and configuration of SQL Server 2000 on Window NT OS.
- Implementing Backups and Restoring when necessary.
- Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
- Developed DTS Packages to transfer the data between SQL Server database and files.
- Extensively Developed SQL scripts for maintaining administration tasks.
0-5 years of experience
As a part of a team, involved in support of several SQL Server 7.0/2000 instances related to a project management application.
- Performed MS SQL Server 7.0/2000 administration in a non-clustered environment.
- Performed data transformation using DTS Wizards and DTS Packages.
- Performed Database Design, Data Modeling and Development.
- Upgraded SQL Server 7.0 to SQL 2000 version and applied SQL server service packs and security patches.
- Migrated SQL 7.0 databases to SQL server 2000.
- Performed SQL server performance tuning and troubleshooting.
- Created and maintained Windows NT/2000 and SQL Server logins and user accounts.
- Performed routine DBA maintenance tasks like planning, monitoring databases, logs for errors.
- Created several T-SQL stored procedures to generate crystal reports and fixed bugs in the old reports.
- Created Database Views, Triggers, Indexes.
0-5 years of experience
As MSFT DBA, provided direct Database administration support to OneNeck customers and Operations. The main goal is to focus on implementing database administration tasks required by customer base. In cooperation with other teams, we are the point of contact for all aspects of Database administration. This also included participation in project based work on a group level. As a DBA was also a subject matter expert and as a resource for the test of the operations team.
- Technical Architecture review of new and existing customer database work requests and what is technically possible in any given scenario.
- Design and tune the databases, high availability and disaster recovery methods by gathering SLA’s, acceptable downtime etc.
- Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes
- Configured Database mirroring as the disaster recovery solution, clustering as the high availability solution. Also configured replication to achieve scalability of databases and improve read performance.
- Monitored server level and DB level log events using SQL Server Audit
- Minimized the backup-time, restore-time, disk I/O and storage required for backups with Backup Compression. Performed database and data file backups on all the databases as required.
- Created SSIS Packages to migrate the data from database to Text files.
- Deployed builds in Production servers for schema changes and worked in CMR(Change Management Request) department
- Worked with several teams and lead database team in the process of development of a Disaster Recovery and high availability solutions.
- Currently tested Database Mirroring as our solution for high availability and disaster recovery. Suggested data obfuscation methodologies for development environment adhering to the company’s security standards.
0-5 years of experience
As MSFT DBA, provided direct Database administration support to OneNeck customers and Operations. The main goal is to focus on implementing database administration tasks required by customer base. In cooperation with other teams, we are the point of contact for all aspects of Database administration. This also included participation in project based work on a group level. As a DBA was also a subject matter expert and as a resource for the test of the operations team.
- Technical Architecture review of new and existing customer database work requests and what is technically possible in any given scenario.
- Design and tune the databases, high availability and disaster recovery methods by gathering SLA’s, acceptable downtime etc.
- Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes
- Configured Database mirroring as the disaster recovery solution, clustering as the high availability solution. Also configured replication to achieve scalability of databases and improve read performance.
- Monitored server level and DB level log events using SQL Server Audit
- Minimized the backup-time, restore-time, disk I/O and storage required for backups with Backup Compression. Performed database and data file backups on all the databases as required.
- Created SSIS Packages to migrate the data from database to Text files.
- Deployed builds in Production servers for schema changes and worked in CMR(Change Management Request) department
- Worked with several teams and lead database team in the process of development of a Disaster Recovery and high availability solutions.
- Currently tested Database Mirroring as our solution for high availability and disaster recovery. Suggested data obfuscation methodologies for development environment adhering to the company’s security standards.
0-5 years of experience
[company name] provides Automated Teller Machine (ATM) E-Solutions for Banking Industry. SQL Server databases were used as relational data warehouse to store the ATM transactions for reporting purpose. DTS packages were developed to receive transaction files from remote FTP sites and import ATM transactions into SQL tables. SQL Reporting service was used to build and manage a variety of financial reports. During my stay at EastCom, we administer 30 SQL 2000 instances and cover most of the SQL administration areas.
- SQL Server 2000 Installation, Upgrade, Patching, and Configuration, Security planning, review and auditing
- DTS package development, testing, and scheduling, data importing and exporting
- Database system performance monitoring and tuning, Index design and tuning, Query tuning
- Create SOPs (standard operational procedure) and Job Aid for the SQL team to provide guidelines, including SQL Server 2000 installation and verification instructions, SQL Server 2000 Service Pact installation and verification instructions, Database Backup and Restore Standard Operational Procedures and Security Review Standard Operational Procedure. SA or SA level account management job aid
0-5 years of experience
- Responsible for reviewing and re-architecture initiative for the SQL Server environment.
- Responsible for maintaining, monitoring, and troubleshooting SQL Server performance issues.
- Developed custom scripts for monitoring and collecting performance trending data.
- Responsible for implementing new methods of automating various maintenance processes related to the SQL Server environment.
- Assisted with SOX audit compliance tasks as it related to the SQL Server environment.
- Researched disk alignment methods in order to increase SQL Server performance.
- Periodically functioned as a member of the Windows Server OS Administration\Build Team.
- Routinely counseled the development team members in the areas of SQL Server and query performance.
- Software tools utilized: SQLH2, SQL Server 2005, SQL Server 2000, SQL Server 7.0
0-5 years of experience
Work with Senior Database staff by maintaining databases for test and production purposes for assigned projects.
- Responsible for creating SSRS Report development of a new Solar Soft database for the Management team.
- Write Stored Procedures & User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
- Created, implemented, deployed and maintaining a reporting suite of standard reports while also customizing many reports to meet individual user’s needs.
- Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
- Responsible for improving performance by creating/using Indexes efficiently, implementing queries as Stored Procedures, managing locks, and working efficiently with Transactional SQL queries, creating procedures using SQL scripting.
- Created stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.
- Create jobs, SQL Mail, Alerts and Schedule SSIS Packages using SQL Server Agent and Report abnormal discrepancies to the Database Manager.
- Importing data into SQL Server DB from Extract tool and analyzing data for reporting purposes.
- Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.
0-5 years of experience
Installed and configured SQL Server on both stand-alone and clustered platforms
- Monitored database performance and played the role of consultant to Development Teams
- Identified root cause and implement short and long term fixes for issues (Problem Management)
- Performed proactive audits and analysis on SQL Instances, databases storage configuration
- Managed the Log Shipping and Transactional Replication of all production environments
- Fine-tuned databases, indexes and processes for optimal performance
- Managing Clustered Servers.
- Optimized the design of large Databases which are TB in size
- Experience of handling 800+ GB Database
- Database files and file group management.
- Creation of AG Groups on always on high availability in SQL Server 2012.
6-10 years of experience
- Support over 50 Supplier Quality Systems via information gathering from several business customers.
- Responsible for migrating 50+ legacy web applications to current Microsoft technologies (classic ASP and ASP.Net 1.0).
- Migration of legacy MS Access applications to SQL Server driven solutions via stored procedures, triggers, and DTS jobs to ensure HS inspector quality via email notifications for eye exams, supplier audits and contractor audits.
- Developer web-based solutions via ASP.Net and VB.Net as well as SQL Server.
- Responsible for initial user-interface and architecture design for software deliverables.
0-5 years of experience
Responsible for standards and design of physical data storage, maintenance, access, and security administration
- Comply with Change Control Procedures by working on tasks/tickets assigned to Database Operations Queues within BMC Remedy and Salesforce
- Responsible for the day to day database administrative tasks, such as: proactive monitoring via SCOM and Spotlight, error checking, performance tuning, transactional/snapshot replication, back-up and recovery
- Perform data analysis via T-SQL, RedGate, and Toad to ensure necessary contract and patient data is transferred to new databases and validated for integrity as part of conversion process
- Install and configure SQL Server 2008/SQL Server 2008 R2 Reporting Services, Engine, SSIS
- Work with IT Auditors to collect database access information for SOX Audits to keep in compliance
- Create routines through the use of T-SQL scripts for collecting database related metrics
- Provide DBMS and database knowledge to Developers, Business Analysts, Account Managers, and QA
- Build/deploy SSIS packages and T-SQL scripts for migrating claim, contract, patient data for clients
- Created SSIS package (through the use of Business Intelligence Studio) to automate a manual business process taking over 45 minutes and reduced completion time to under 1 minute
- Provide on-call support for a production environment consisting of approximately 10,000+ databases on 600+ servers ranging in size from 50 MB to 4 TB
0-5 years of experience
Software design/programming to support existing code base using C#, ASP.Net & VB.Net (Visual Studio 2012 with Team Foundation Server 2010) development and IIS web server including SharePoint administration.
- Creating custom reports using SQL Server Reporting Services (SSRS).
- Construction of web services & windows services using C# to consolidate common code into easily accessible objects to be consumed by existing & future applications.
- Maintenance and development of web site (Vendor) as well as internal web site using VB.Net and ASP.Net (Visual Studio 2012).
- Custom code maintenance and development to include 45 scheduled jobs, inventory replenishment tools and other custom VB.Net & VBA software which comprised roughly 130 separate Visual Studio solutions/projects.
- Migrating existing VB.Net (2003 & 2005) code base to C# (VS 2012).
- Monitoring server health, capacity planning, analyzing risk & reporting potential problems.
- Diagnosing critical failures in existing software infrastructure & redesigning modules to decrease overall failure rate.
- Constructing common software libraries/web services for use in applications.
0-5 years of experience
- Product management activities were increased to include directing the activities of all RDBMS product teams: Oracle, Sybase, Informix and Teradata. Also included defining priorities, project plans contract and vendor negotiations.
- Documented all SQL server best practices, guidelines and procedures supporting: maintenance, object naming conventions, improvement of security in SQL 2000. Supported creation of database and application for SQL DBMS host management system. Used by DBA’s to monitor, report and maintain SQL servers, instances and databases. Lead DBA on project using Agile project methodologies.
- Work with developers to create and optimize database objects: stored procedures, functions and views. Create best practices for installation and use of SQL Server 2000. Participated in projects to migrate SQL7 databases to SQL 2000. Worked with application teams to provide guidance for selection of 3rd party products.
0-5 years of experience
- Primary candidate for skillsets such as: SQL Server DBA, Oracle DBA, Java Developers, C# Developers, Network Engineers, System Engineers, ETL developer, Desktop and helpdesk, Network Engineers, System Engineers, ASP.net and etc
- Assisted Human Resource in sourcing, scheduling, screening and recruiting branch candidates.
- Coordinate schedules between candidates and hiring managers.
- Assist in setting up packages for new hire training.
- Out bound calls to candidates to coordinate interview times, review internal testing and verify candidates met minimum guidelines for corporate policy.
0-5 years of experience
Primary SQL Server DBA, Installed and maintaining SQL Server 2008 R2, 2012 and 2014.
- Designed Campus BI Solution. This is a business analysis project. Tool and technologies used: SharePoint 2010, SQL Server 2008 R2, SSIS, SSAS, PowerPivote, PowerView.
- IBM DataStage System Admin, Installed and maintaining InfoSphere System Suit V.9.1 on both Production and Test environments, includes DataStage, QualityStage, FastTrack, Metadata Workbench, Information Analyzer and Service Director. Very closely supporting GTRI, Housing, CRC, ITG and other departments cross campus.
- ETL Developer, Using both SSIS and DataStage, extract, transform and loading data from/to different data repository. (SQL Server, Oracle, XML, CSV, Text)
- Business Intelligent Developer. Use ETL tool retrieving data from all Georgia Tech’s Business branch to our central SQL Server Data Mark. Use Microsoft PowerPivot and PowerView create on demand reports and then deploy them to SharePoint.
- SharePoint developer. Using C# write web parts and deploy them to Georgia Tech’s SharePoint Server, which is Georgia Tech’s Public portal.
0-5 years of experience
Serving as lead on the [company name] data warehouse and data dashboards.
- Leading an initiative to resolve data quality and integrity issues and currently working on a strategy for data quality governance.
- Automated database maintenance plans for the [company name].
- Troubleshoot performance problems, fine tune of databases and index analysis.
- Design and built tables, views, triggers, and stored procedures.
- Modeling current data for both scalability and efficiency.
- Mentor team members on writing efficient and reusable queries.
- Experience on SQL Server 2012, and SQL Server 2008 R2.
- Leading the effort to move from Crystal Reports to SSRS.
- Assign and prioritize tasks to team members.
0-5 years of experience
Administer and Maintain SQL Server 2000, 2005, 2008, 2008 R2, 2012 servers. Supporting over 190 SQL servers running 2500 databases.
- Production Support (performance issues, space management, maintenance plans, change controls, incident ticket management). Provide Support to 60+ application teams for application build in-house and third party application.
- Install\configure\upgrade\patch SQL server Stand Alone and Clustered instances. Work with SAN Storage team\Active Directory Team\Windows Team\Tape Backup (NETBACKUPS) to ensure prerequisites are met for new server build. Configure storage\Windows Server for optimal performance to SQL Server standard before SQL Server build.
- Built Shared Infrastructure with Clustering to provide High Availability which helped consolidate 20 servers and saving licensing cost.
- Worked on SharePoint 2007 running on SQL 2005 to migration to SharePoint 2010 running on SQL 2008 R2. Architected and build High Availability 3 node cluster to migrate 190 databases with 7 TB of data with least amount of database down time.
- Review and deploy code to lower environments and production (SDLC). Provide feedback related to code performance to developers\application teams before production releases. Promote Code changes to the Development, QA, and Production server using BMC Remedy Change
- Utilize SQL Profiler trace, collect and analyze Perfmon data with use of Performance Analysis of Logs (PAL) reports to troubleshoot database\SQL server related performance issues.
- Monitoring and maintaining log shipping between production SQL Servers and Contingency servers.
- Create and Maintain SQL server standards.
- Document procedures, knowledge articles and provide training to DBAs. Provide technical guidance to DBA team on production issues and complex projects.
- Provide 24×7 support for production servers.
0-5 years of experience
- Created, administered and maintained Databases
- Monitor the Database Server Performance
- Reviewed and tuned SQL queries, stored procedures
- Used SQL Profiler for performance tuning
- Responsible for configuring Replication – Snapshot and Transactional
- Responsible for configuring and monitoring Mirroring
- Used Litespeed for Database Backup
- Used Database Loader for restoring Database
- Involved in designing and implementing an Disaster Recovery Plan
- Interacting with the customer (Connecticut State Lottery)
0-5 years of experience
- SQL Server Administration – including installation, configuration, upgrades, backups, and restores
- Incident/Problem management in a process driven environment
- High availability
6-10 years of experience
- Provide 24×7 on call support and problem resolution as necessary.
- DBA support includes: perform database capacity planning; create, administer and maintain databases; install and patch
- Monitor database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization
- Providing consultation on Oracle/SQL Server to our development team.
- Design, creation, configuration, recovery and support of Oracle/SQL Server databases & clusters
- Performed 1st tier Production support by troubleshooting database issues, performance monitoring/tuning, & capacity planning for Oracle (Some RAC environment)/SQL Server databases (clustered environment)
- Provide database architecture, design, configuration, & development experience with all database platforms
0-5 years of experience
- Develop, test, and implement: Backup solutions and schedules, customized SQL Server and Oracle installations, database and data migrations, upgrades, database and server configurations and modifications, performance tuning along with developing testing scenarios, and execute production changes through a change management process, Create, administer, and verify successful completion of all daily and weekly database maintenance, Detect and repair database errors, Implement sustainable database configurations.
- Instruct, guide, and negotiate with developers in the creation and modification of production database applications, which conform to standardized coding and security requirements
- Establish and enforce testing requirements for new database applications, upgrades, and COTS applications prior to production implementation
- Design, develop, test, and execute backup and recovery for y2k and disaster recovery scenarios
SQL Server DBA Duties and Responsibilities
SQL Server DBAs can work in a variety of organizations, but most of them share several core duties in any setting:
Manage SQL Databases The main responsibility of a SQL Server DBA is managing the development and performance of SQL databases for web applications, businesses and organizations, and educational institutions. A SQL Server DBA uses their experience with data architecture and management to develop and scale SQL databases based on their organization’s needs. They may also configure servers and processes and automate tasks to improve reliability and cut down on development time.
Direct SQL Developers SQL Server DBAs usually manage a team of SQL developers, directing them throughout the process of writing and deploying database code. This can include providing guidance on complex queries and the optimization of processes and statements. The SQL Server DBA may also share their knowledge through mentorship and direct training of team members and developers.
Conduct Database Troubleshooting and Maintenance The SQL Server DBA conducts troubleshooting and bug fixing on databases and applications, resolving issues without excessive downtime or data loss. They may need to validate data and perform extensive testing to ensure that the database systems and access programs meet the end user’s requirements. SQL Server DBAs also ensure that data is intact, correct, and accessible after a server migration or backup.
Gather Requirements Another important responsibility of the SQL Server DBA is gathering requirements and specifications from end users. The SQL Server DBA uses this information to design and structure data and grant access to users. Additionally, the SQL Server DBA shares these requirements with developers on their team to guide development projects and ensure that the system meets functional requirements.
Enhance and Improve Systems Finally, SQL Server DBAs constantly seek out methods to better handle data and increase system efficiency. This can mean assisting developers with writing more complex and optimized queries, changing data structures, or automating tasks to decrease development time. SQL Server DBAs may also propose and develop improved methodologies and institute best practices around database security and access.
SQL Server DBA Skills and Qualifications
The SQL Server DBA combines analytical and leadership roles to successfully meet organizations’ data management and access needs. SQL Server DBAs should have at least a bachelor’s degree, a background working with SQL servers, and the following skills:
- Data management – SQL Server DBAs need extensive familiarity with data management principles and best practices in order to properly store, migrate, and structure data for multiple applications
- Server development and maintenance – this role also requires a strong grasp of server development and maintenance, including troubleshooting, data migration, and backup and recovery tasks
- Problem-solving skills – SQL Server DBAs should be skilled creative and technical problem-solvers, able to isolate and resolve database issues in real time to maintain access and data integrity
- Software programming – while SQL Server DBAs don’t write much code, they may advise developers on operations, scripts, and triggers to improve database access, and should be familiar with one or more scripting languages
- Communication skills – SQL Server DBAs communicate to direct their teams, gather requirements, and prepare reports related to database issues
- Process enhancement – finally, SQL Server DBAs should be skilled at developing more efficient processes for handling and accessing data, automating recurring tasks, and performing routine maintenance
SQL Server DBA Education and Training
SQL Server DBAs typically have at least a bachelor’s degree in a related field, such as computer science or information systems. SQL Server DBAs should have significant experience with SQL server administration or development and should be familiar with principles and best practices in developing and maintaining responsive, secure, and accessible servers. In addition, SQL Server DBAs should achieve SQL Server certification from Microsoft to improve their employment prospects.
SQL Server DBA Salary and Outlook
The Bureau of Labor Statistics (BLS) estimates that database administrators, including SQL Server DBAs, earn a median annual wage of $87,020. The lowest-paid 10 percent of database administrators earn less than $48,480 per year, while the highest-paid 10 percent earn over $132,420 annually. The BLS expects employment for database administrators to grow at a faster-than-average rate of 11 percent through 2026 as more companies rely on data-driven processes and need administrators to oversee data management processes and technologies.
Helpful Resources
If you’re interested in learning more about becoming a SQL Server DBA, we identified several resources on the web for further reading:
Microsoft SQL Server Certifications – certification is often a requirement for SQL Server DBAs, and Microsoft offers several courses that can help open up career and advancement opportunities
Securing SQL Server: DBAs Defending the Database – this book focuses on data security, with a particular focus on the role of the SQL Server DBA and steps they can take to enhance data protection measures
“5 Critical DBA Best Practices” – this blog post offers advice and best practices for SQL Server DBAs, including advice on standardization, limiting SQL server access, and following proper backup and restoration plans
SQL Server 2017 Administration Inside Out – read this book for a deep dive into SQL
server administration. The text focuses on the 2017 edition but covers general principles that will remain useful throughout your career
Data Systems Administration Cover Letter Examples
Rate This Article
[SQL Server DBA]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
