Sql database administrator job description
Updated March 14, 2024
11 min read
A SQL database administrator is responsible for the creation and maintenance of a client's databases via the programing language known as SQL. Their duties include solving database issues, preparing design reports, educating staff members on database etiquette, and running tests and repairs as necessary.
Find better candidates in less time
Post a job on Zippia and take the best from over 7 million monthly job seekers.
Example sql database administrator requirements on a job description
Sql database administrator requirements can be divided into technical requirements and required soft skills. The lists below show the most common requirements included in sql database administrator job postings.
Sample sql database administrator requirements
- Proficient in SQL database administration
- Experience with database backup and recovery procedures
- Knowledge of database security protocols and best practices
- Ability to troubleshoot and resolve database issues
- Familiarity with database management tools and software
Sample required sql database administrator soft skills
- Excellent communication and interpersonal skills
- Strong problem-solving and analytical skills
- Ability to work independently and as part of a team
- Willingness to learn and adapt to new technologies
- Attention to detail and commitment to accuracy
Sql database administrator job description example 1
Selective Insurance sql database administrator job description
Selective is seeking a Senior SQL DBA to partner with Architects and Engineers within IT Infrastructure, supporting our business platforms and continuously improve to meet the evolving needs of our business community. The Senior SQL DBA will provide technical leadership to the DBA team to help drive the strategic initiatives at Selective Insurance. Primarily focused on SQL while providing superior levels of performance and customer service.
Responsibilities
Provide leadership in IT for the development of highly appropriate, tightly integrated, consistently available, secure, flexible, and fault-tolerant database solutions Ability to Design and implement standardized methodologies to deploy and maintain highly available database environments running Microsoft SQL Server on Windows OS Work with architecture team to prepare recommendations and supporting details for formal project proposals for database design and configurations Perform as SME escalation in support of IT operational organization during complex highly impactful outages that can cross multiple functional domains, involving chronic recurring problems, vendor product bugs and other critical database functionality Performance tune complex SQL statements Serve as a data professional as we leverage cloud solutions Participate in disaster recovery tests. Ensure all engineered solutions have sufficient design documentation available including HLD and LLD documents.
Ensure all engineered solutions and features take operational needs into account and provide the Operations team with sufficient documentation, training and standard operating procedures that support daily operation, maintenance, upgrades and support escalations for the solution. Identify areas for enhanced efficiency through automation and streamlined workflow. Develop innovative solutions to complex business and technology problems Work with Information Security to ensure that security policies are properly engineered into the delivered solutions and features.
Acting as an escalation focal point for our client on behalf of I&O organization. Identifying, documenting and implementing process improvements initiatives Lead, participate and coordinate in client governance model
Present monthly operational report and KPI's to the client.
Qualifications
College degree in Computer Science or a related field preferred. 10 + years of relevant experience in a fast-paced, enterprise-level environment including leadership roles 10+ years' experience in database design, deployment, migration, tuning and administration Experience designing/deploying databases to the Cloud (Azure, AWS, Google) Ability to write, tune SQL queries, experience in writing procedural language artifacts: PL/SQL, T-SQL, PL/pg SQL, stored procedures Ability to create accurate database diagrams and documentation for design and planning database layout Advanced level knowledge of SQL Server (2012, 2016, 2017, 2019), Polybase, and experience with database monitoring /administration tools required Experience with DB2, DB2LUW 11.1, 11.5, Oracle 11g, 12c, 119c and IIAS a plus Experience with Idera database monitoring / administration tools a plus Strong knowledge of native database backup and recovery, experience with Cohesity database backup/restore a plus Database and Cloud certifications desirable from leading vendors Ability to work with vendors and research product offerings to determine appropriate solutions. Ability to review, evaluate and make recommendations on vendor SOW's, BOM's and proposals. Able to function in complex and challenging customer environments while maintaining the ability to influence change and negotiate mutually beneficial solutions. customer centric mindset Demonstrate good communication skills and the ability to clearly articulate technology topics within all levels of Selective, including senior management
Selective is an Equal Employment Opportunity employer. Selective maintains a drug-free workplace.
#LI-BB1
Responsibilities
Provide leadership in IT for the development of highly appropriate, tightly integrated, consistently available, secure, flexible, and fault-tolerant database solutions Ability to Design and implement standardized methodologies to deploy and maintain highly available database environments running Microsoft SQL Server on Windows OS Work with architecture team to prepare recommendations and supporting details for formal project proposals for database design and configurations Perform as SME escalation in support of IT operational organization during complex highly impactful outages that can cross multiple functional domains, involving chronic recurring problems, vendor product bugs and other critical database functionality Performance tune complex SQL statements Serve as a data professional as we leverage cloud solutions Participate in disaster recovery tests. Ensure all engineered solutions have sufficient design documentation available including HLD and LLD documents.
Ensure all engineered solutions and features take operational needs into account and provide the Operations team with sufficient documentation, training and standard operating procedures that support daily operation, maintenance, upgrades and support escalations for the solution. Identify areas for enhanced efficiency through automation and streamlined workflow. Develop innovative solutions to complex business and technology problems Work with Information Security to ensure that security policies are properly engineered into the delivered solutions and features.
Acting as an escalation focal point for our client on behalf of I&O organization. Identifying, documenting and implementing process improvements initiatives Lead, participate and coordinate in client governance model
Present monthly operational report and KPI's to the client.
Qualifications
College degree in Computer Science or a related field preferred. 10 + years of relevant experience in a fast-paced, enterprise-level environment including leadership roles 10+ years' experience in database design, deployment, migration, tuning and administration Experience designing/deploying databases to the Cloud (Azure, AWS, Google) Ability to write, tune SQL queries, experience in writing procedural language artifacts: PL/SQL, T-SQL, PL/pg SQL, stored procedures Ability to create accurate database diagrams and documentation for design and planning database layout Advanced level knowledge of SQL Server (2012, 2016, 2017, 2019), Polybase, and experience with database monitoring /administration tools required Experience with DB2, DB2LUW 11.1, 11.5, Oracle 11g, 12c, 119c and IIAS a plus Experience with Idera database monitoring / administration tools a plus Strong knowledge of native database backup and recovery, experience with Cohesity database backup/restore a plus Database and Cloud certifications desirable from leading vendors Ability to work with vendors and research product offerings to determine appropriate solutions. Ability to review, evaluate and make recommendations on vendor SOW's, BOM's and proposals. Able to function in complex and challenging customer environments while maintaining the ability to influence change and negotiate mutually beneficial solutions. customer centric mindset Demonstrate good communication skills and the ability to clearly articulate technology topics within all levels of Selective, including senior management
Selective is an Equal Employment Opportunity employer. Selective maintains a drug-free workplace.
#LI-BB1
Post a job for free, promote it for a fee
Sql database administrator job description example 2
Komatsu America Corp. sql database administrator job description
Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and technology to enhance safety and productivity while optimizing performance. Komatsu supports a myriad of markets, including housing, infrastructure, water, pipeline, minerals, automobile, aerospace, electronics and medical, through its many brands and subsidiaries, including TimberPro, Joy, P&H, Montabert, Modular Mining Systems, Hensley Industries, NTC, and Gigaphoton.
We have an exciting opportunity for a SQL Database administrator to join our global IT team. This role can be based at our office in Milwaukee, WI or Chicago, IL (near O'Hare). We offer a hybrid work schedule (2 days per week in the Milwaukee or Chicago office for collaboration, team meetings, working sessions, etc. and up to 3 days per work can be telecommuting from your home office).
Key Job Responsibilities
Partner with IT application architects, data architects, and infrastructure architects to plan and meet corporate SQL standards and business goals Assist with developing databases to support web based, high volume transaction applications Work with IT to ensure compliance with corporate policy. Building and maintaining moderately complex stored procedures in collaboration with .NET programmers. Developing data extracts from existing SQL databases, backup and recovery of database sites and utilization of https, IIS, Windows and .NET programming techniques Administer Windows 2016 and newer and SQL Server 2016 and newer platforms Monitor and tune performance database environments Migration of systems from SQL 2012 and 2016 to newer editions.Migration of On-Premises systems and application databases to Azure IaaS or PaaS Knowledge of Azure Data Factory and migrating SSIS Workflows and ETLs to ADF. Active monitoring of SQL Instances for proactive support of availability and recoverability.
Qualifications/Requirements
Bachelor's degree in MIS, Computer Science, a related major or equivalent work experience 4+ years as a database administrator with three plus years SQL Server 2016 and newer The ideal candidate will have deep experience in database administration involving management of multiple SQL databases in a highly dynamic environment Must have knowledge of SQL Utilities (BCP, DTS, SSIS-2016+, SSAS, PowerBI, etc) Experience with creation and implementation of fully functional SQL Server databases, ability to maintain multiple development and QA SQL Server environments Experience with Replication, Clustering, Always On and other HA architectures Strong experience with performance tuning on MS SQL Server, experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency Advanced knowledge of T-SQL and ability to write stored procedures, UDF's and triggers, debugging and performance tuning stored procedures, index analysis; various monitoring and tuning tools such as Profiler, Spotlight, advanced installation and configuration procedures and data normalization Proven competence with partitioning, advanced queuing, cursors, etc. Must have basic working knowledge of hardware, networking and SQL Server connectivity and the tools needed to troubleshoot and diagnose issues with them. Team player with excellent verbal and written communication skills
Additional Information
Komatsu is an Equal Opportunity Workplace and an Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
We have an exciting opportunity for a SQL Database administrator to join our global IT team. This role can be based at our office in Milwaukee, WI or Chicago, IL (near O'Hare). We offer a hybrid work schedule (2 days per week in the Milwaukee or Chicago office for collaboration, team meetings, working sessions, etc. and up to 3 days per work can be telecommuting from your home office).
Key Job Responsibilities
Partner with IT application architects, data architects, and infrastructure architects to plan and meet corporate SQL standards and business goals Assist with developing databases to support web based, high volume transaction applications Work with IT to ensure compliance with corporate policy. Building and maintaining moderately complex stored procedures in collaboration with .NET programmers. Developing data extracts from existing SQL databases, backup and recovery of database sites and utilization of https, IIS, Windows and .NET programming techniques Administer Windows 2016 and newer and SQL Server 2016 and newer platforms Monitor and tune performance database environments Migration of systems from SQL 2012 and 2016 to newer editions.Migration of On-Premises systems and application databases to Azure IaaS or PaaS Knowledge of Azure Data Factory and migrating SSIS Workflows and ETLs to ADF. Active monitoring of SQL Instances for proactive support of availability and recoverability.
Qualifications/Requirements
Bachelor's degree in MIS, Computer Science, a related major or equivalent work experience 4+ years as a database administrator with three plus years SQL Server 2016 and newer The ideal candidate will have deep experience in database administration involving management of multiple SQL databases in a highly dynamic environment Must have knowledge of SQL Utilities (BCP, DTS, SSIS-2016+, SSAS, PowerBI, etc) Experience with creation and implementation of fully functional SQL Server databases, ability to maintain multiple development and QA SQL Server environments Experience with Replication, Clustering, Always On and other HA architectures Strong experience with performance tuning on MS SQL Server, experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency Advanced knowledge of T-SQL and ability to write stored procedures, UDF's and triggers, debugging and performance tuning stored procedures, index analysis; various monitoring and tuning tools such as Profiler, Spotlight, advanced installation and configuration procedures and data normalization Proven competence with partitioning, advanced queuing, cursors, etc. Must have basic working knowledge of hardware, networking and SQL Server connectivity and the tools needed to troubleshoot and diagnose issues with them. Team player with excellent verbal and written communication skills
Additional Information
Komatsu is an Equal Opportunity Workplace and an Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Dealing with hard-to-fill positions? Let us help.
Sql database administrator job description example 3
BAE Systems sql database administrator job description
BAE is looking for a seasoned cloud DBA to join our team. This person will work to manage the deployment of and maintenance of the application related database objects in a large, complex, and distributed environment used by dozens of applications.They will also be expected to provide other Database Administrator (DBA) functions such as daily monitoring, preventative maintenance, tuning, and configuration support for the databases in our different environments, production, testing and development. Our team is primarily working remotely with one day a week at the customer site.
Teamwork is a key element of the position, not just with the DBA team, but also with the developers and system owners when resolving issues as well as when planning and executing application deployments, bug fixes, and database or system enhancements.This person needs to have good observational and analytical skills to help identify and resolve issues with the systems and deployments before and after they occur.
THIS POSITION IS MOSTLY REMOTE
FEDCIV
Required Education, Experience, & Skills
Setting up high availability and failover support. Understanding the Amazon Virtual Private Cloud (VPC) network Importing data into Amazon RDS PostgreSQL Setting up read-only read replicas (primary and standbys) Understanding security groups Setting up parameter groups and features Performing common DBA tasks for PostgreSQL Understanding the rds_superuser role Managing PostgreSQL database access Working with RDS for PostgreSQL parameters Working with PostgreSQL autovacuum on Amazon RDS Audit logging for a PostgreSQL DB instance Working with the PostGIS extension Analyze PostgreSQL log files Backing up and restoring DB instance Monitoring the activity and performance of the DB instance Ability to upgrade the PostgreSQL database Working with log files Understanding the best practices for PostgreSQL DB instances
MySQL on Amazon RDS
Setting up high availability and failover support Understanding the Amazon Virtual Private Cloud (VPC) network Importing data into Amazon RDS MySQL Setting up read-only read replicas (primary and standbys) Understanding security groups Setting up parameter groups and features Performing common DBA tasks for MySQL Understanding the rds_superuser role Managing MySQL database access Working with RDS for MySQL parameters Audit logging for a MySQL DB instance Working with the MySQL extension Analyze MySQL log files Backing up and restoring DB instance Monitoring the activity and performance of the DB instance Ability to upgrade the MySQL database Working with log files Understanding the best practices for MySQL DB instances
Typical Education and Experience:
Bachelor's degree in Computer Science or related IT or Engineering field, or equivalent experience. Typically a BS Degree and 8 years work experience or equivalent experience.
The Candidate must possess an active Top Secret Security Clearance
Preferred Education, Experience, & Skills
Cloud certifications for AWS or Azure.
About BAE Systems Intelligence & Security
BAE Systems Intelligence & Security, based in McLean, Virginia, designs and delivers advanced defense, intelligence, and security solutions that support the important missions of our customers. Our pride and dedication shows in everything we do-from intelligence analysis, cyber operations and IT expertise to systems development, systems integration, and operations and maintenance services. Knowing that our work enables the U.S. military and government to recognize, manage and defeat threats inspires us to push ourselves and our technologies to new levels. That's BAE Systems. That's Inspired Work.Equal Opportunity Employer/Females/Minorities/Veterans/Disabled/Sexual Orientation/Gender Identity/Gender Expression. To see Inspired Work in action, visit www.baesystems.com and follow us on Facebook: www.facebook.com/baesystemsintel.
Teamwork is a key element of the position, not just with the DBA team, but also with the developers and system owners when resolving issues as well as when planning and executing application deployments, bug fixes, and database or system enhancements.This person needs to have good observational and analytical skills to help identify and resolve issues with the systems and deployments before and after they occur.
THIS POSITION IS MOSTLY REMOTE
FEDCIV
Required Education, Experience, & Skills
Setting up high availability and failover support. Understanding the Amazon Virtual Private Cloud (VPC) network Importing data into Amazon RDS PostgreSQL Setting up read-only read replicas (primary and standbys) Understanding security groups Setting up parameter groups and features Performing common DBA tasks for PostgreSQL Understanding the rds_superuser role Managing PostgreSQL database access Working with RDS for PostgreSQL parameters Working with PostgreSQL autovacuum on Amazon RDS Audit logging for a PostgreSQL DB instance Working with the PostGIS extension Analyze PostgreSQL log files Backing up and restoring DB instance Monitoring the activity and performance of the DB instance Ability to upgrade the PostgreSQL database Working with log files Understanding the best practices for PostgreSQL DB instances
MySQL on Amazon RDS
Setting up high availability and failover support Understanding the Amazon Virtual Private Cloud (VPC) network Importing data into Amazon RDS MySQL Setting up read-only read replicas (primary and standbys) Understanding security groups Setting up parameter groups and features Performing common DBA tasks for MySQL Understanding the rds_superuser role Managing MySQL database access Working with RDS for MySQL parameters Audit logging for a MySQL DB instance Working with the MySQL extension Analyze MySQL log files Backing up and restoring DB instance Monitoring the activity and performance of the DB instance Ability to upgrade the MySQL database Working with log files Understanding the best practices for MySQL DB instances
Typical Education and Experience:
Bachelor's degree in Computer Science or related IT or Engineering field, or equivalent experience. Typically a BS Degree and 8 years work experience or equivalent experience.
The Candidate must possess an active Top Secret Security Clearance
Preferred Education, Experience, & Skills
Cloud certifications for AWS or Azure.
About BAE Systems Intelligence & Security
BAE Systems Intelligence & Security, based in McLean, Virginia, designs and delivers advanced defense, intelligence, and security solutions that support the important missions of our customers. Our pride and dedication shows in everything we do-from intelligence analysis, cyber operations and IT expertise to systems development, systems integration, and operations and maintenance services. Knowing that our work enables the U.S. military and government to recognize, manage and defeat threats inspires us to push ourselves and our technologies to new levels. That's BAE Systems. That's Inspired Work.Equal Opportunity Employer/Females/Minorities/Veterans/Disabled/Sexual Orientation/Gender Identity/Gender Expression. To see Inspired Work in action, visit www.baesystems.com and follow us on Facebook: www.facebook.com/baesystemsintel.
Start connecting with qualified job seekers
Resources for employers posting sql database administrator jobs
Average cost of hiring
Recruitment statistics
How to write a job description
Examples of work conditions
Sql database administrator job description FAQs
Ready to start hiring?
Updated March 14, 2024
Updated March 14, 2024