SENIOR DATABASE ADMINISTRATOR SKILLS, EXPERIENCE, AND JOB REQUIREMENTS
Updated: Oct 28, 2024 – The Senior Database Administrator has experience developing and maintaining mission-critical database environments, including proficiency in SQL Server replication and High Availability features. This role requires a strong understanding of database design, referential integrity, and the application development life cycle, particularly in high-transaction OLTP environments. The administrator also possesses excellent T-SQL and PowerShell skills, along with a commitment to effective communication, collaboration, planning, and documentation.
Essential Hard and Soft Skills for a Standout Senior Database Administrator Resume
- SQL Server Administration
- Database Design
- T-SQL
- PowerShell Scripting
- High Availability Solutions
- Database Replication
- Performance Tuning
- Backup and Recovery
- Data Migration
- Monitoring and Troubleshooting
- Problem Solving
- Communication
- Collaboration
- Time Management
- Attention to Detail
- Adaptability
- Critical Thinking
- Planning
- Documentation
- Team Leadership
Summary of Senior Database Administrator Knowledge and Qualifications on Resume
1. BS in Business Analytics with 8 years of Experience
- Substantial experience in the provision of high-level information support and services
- Demonstrate experience working with large datasets, data analysis and presentation of key insights into a form easily digested and understood
- Experience in the development and implementation of Dashboarding tools and reports like Tableau *Preferred
- Experience with statistical/predictive modeling and modeling tools
- Working preference for detail and accuracy
- Working knowledge of data extraction, preparation, blending and cleansing processes
- Experience in managing competing priorities including planning and executing projects to meet customer needs
- Experience in managing large and complex datasets and identifying and actioning data integrity issues on a large scale
- Experience in report creation and presentation using tools such as Excel
- Knowledge of programming languages like SQL, Oracle, R, MATLAB
2. BS in Computer Science with 5 years of Experience
- Working experience in installing, configuring, administering, and tuning database technologies.
- Working experience writing PL/SQL triggers and/or procedures.
- Working experience with configuring and managing advanced queues.
- Working experience configuring and managing replication.
- Working experience with stored procedures, triggers, functions, packages, partitioning, streams and indexes.
- Experience leading other DBAs and working cross-functionally.
- Working experience with UNIX and shell scripts.
- Experience using KEKB (Known-Error Knowledge Base)
- Intellectual curiosity to pursue the unknown and to continuously learn.
- Ability to work in a fast-paced dynamic environment.
3. BS in Cybersecurity with 10 years of Experience
- Experience supporting MySQL NDB Cluster, Galera Cluster for MySQL, MariaDB Galera Cluster and Percona MySQL.
- Hands-on database administration experience using MySQL Server or MariaDB.
- Experience in maintaining large databases, supporting OLTP applications, and good knowledge of Replication technologies.
- Experience in support of database servers or similar products on Unix/Linux platforms.
- Hands-on experience in application development using MySQL
- Systems analysis and design experience
- Experience in software development with scripting languages (Perl, Python)
- Problem-solving skills and ability to work under pressure
- Able to install, configure and maintain MySQL and similar servers (like MariaDB, Percona, etc).
- The ability to monitor the availability and performance of production databases and servers.
- Able to analyze and resolve complex technical problems, including performance tuning, and application design and debugging.
4. BS in Software Engineering with 7 years of Experience
- Experience administering MS SQL Server with experience with the most recent versions 2016 or 2019.
- Comprehensive knowledge of MS SQL high availability environment and Best Practices.
- Mastery of Best Practices for design, setup, configuration and maintenance of Data Warehouse environment to support SSRS and BI tools.
- Understanding of Best Practices for VMware infrastructure for SQL Server
- Security experience working with Endpoint Security, Intrusion Prevention, and Firewall security
- Proven work experience as a system security engineer or information security engineer
- Experience in building and maintaining security systems
- Detailed technical knowledge of database and operating system security
- Hands-on experience in security systems, including firewalls, intrusion detection systems, anti-virus software, authentication systems, log management, content filtering, etc
- Experience with network security and networking technologies and with system, security, and network monitoring tools
5. BS in Information Technology with 6 years of Experience
- Experience working on a PaaS/SaaS managing MySQL/Aurora databases providing critical 24x7 uptime as a Database Administrator
- Experience working with AWS RDS Aurora/MySQL databases on high transactional environments
- Experience working with no-SQL databases (Redis)
- Experience working with hyperscale cloud providers (AWS, Azure, GCP, etc.).
- Understands the LAMP architecture stack from OS/WebServer/Database and Application along with AWS/Network/WAF/CDN
- Experience using/implementing CI/CD frameworks.
- Application deployment (Jenkins, Travis, Gitlab CI, etc.).
- Infrastructure provisioning tools (Chef/Puppet, Ansible, Terraform, etc.).
- Extensive infrastructure automation via shell scripting (Python, BASH, etc.).
- Extensive experience with Monitoring/Logging/Alerting systems.
6. BS in Computer Engineering with 5 years of Experience
- Recent experience developing and maintaining mission-critical database environments
- Experience with SQL Server replication, High Availability, and other SQL Server features
- Clear understanding of database design, referential integrity and the application development life cycle
- Experience in large enterprise high transaction OLTP environments
- Experience in Microsoft SQL Server 2016 and higher
- Strong T-SQL and PowerShell skills
- Experience with database triaging, tuning and monitoring
- Familiarity with standard change control procedures
- Excellent communication and collaboration skills
- Good planning, time management, and documentation skills
7. BS in Computer Science with 11 Years of Experience
- Experience with Microsoft SQL Server duties in a businesscritical, high-availability context.
- Deep understanding of SQL Server internals
- Windows and VMWare ESX experience
- Knowledge of the underlying infrastructure requirements such as Networking, Storage, and Hardware Optimization.
- Strong understanding of SQL Server Db utilities, backup, and recovery
- Strong knowledge of physical database design
- Ability to perform both DB and OS performance tuning and monitoring
- Strong knowledge of SQL Server security, resource management, data integrity, performance tuning and its tools
- Sound communication skills with management, development teams, vendors and systems administrators
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options
- Familiar with DevOps concepts and automation strategies.
- Advanced knowledge in MS SQL performance tuning, query optimization, SSIS, and performance monitoring using commercially available platforms.
- Advanced knowledge of HA and DR options for MS SQL databases.
- Strong understanding of infrastructure to include Windows OS, Linux, Server architecture/setup, and networking
- Experience working in agile development environments.
- Broad understanding of various database technologies outside of MS SQL to include: DB2, Oracle, PostgreSQL, Mongo, Cassandra
- Advanced knowledge in troubleshooting and resolving database performance issues, connectivity issues, and security issues.
8. BA in Information Technology with 12 Years of Experience
- SQL database administration experience
- Experience in the SQL Server DBA role
- Expert hands-on experience with Microsoft SQL Server 2005 through 2017
- Knowledge of Azure SQL, Streaming Analytics, or other Azure data services
- SQL Server enterprise level experience with the following features: SSIS, SSAS, and SSRS administration, Failover Clustering (Always On: FCI & AG) design and configuration, Data replication solutions (i.e. Log Shipping and SQL Replication) configuration, applying data compression on tables and indexes, Troubleshooting performance with SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor
- Knowledge of the following concepts: T-SQL administrative scripting, Analyzing Dynamic Management Views for monitoring database health, Creating SQL Server maintenance plans and/or custom maintenance scripts, Database stored procedure, trigger, and index creation and tuning
- Proficient in installing, upgrading and patching Oracle database
- Expertise in using RMAN to clone a database and in setting up a physical standby database
- Experienced in managing Oracle RAC.
- Hands on experience with Oracle version 12c and above
- Microsoft SQL Server 2008 / 2012 / 2014 / 2016/ 2017 /2019 experience with database administration, including installation and troubleshooting issues
- T-SQL Scripting experience
- Have in depth SQL internal knowledge
- Backup and recovery experience
- Proven working experience as a Database Administrator
- Experience working with MS SQL in a hybrid-environment that includes multiple cloud providers and on-premise data centers.
- Experience working with IaaS/PaaS database solutions in public cloud environments
9. BS in Information Systems with 10 Years of Experience
- Experience in a fast-paced, enterprise-level environment including leadership roles
- 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/pgSQL, 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 z/os, DB2LUW 11.1, 11.5, Oracle 11g, 12c, 119c and IIAS
- Experience with Idera database monitoring / administration tools
- Strong knowledge of native database backup and recovery, experience with Cohesity database backup/restore
- 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.
- Demonstrate good communication skills and the ability to clearly articulate technology topics within all levels of Selective, including senior management
10. BA in Database Management with 5 Years of Experience
- Experience with MS SQL Server System Management and Programming
- Strong knowledge of High Level Query Performance Tuning/Best Practice
- Prior experience in MSSQL Server Systems (2012/2014/2016 new features)
- MSSQL Licencing methods experience
- MSSQL Audit / Monitoring Tools experience is a plus (Guardium, IDERA, PRTG etc.)
- Hardware/OS resources related solution experience on MSSQL Systems
- Has experienced other database types except SQL Server
- Good task executer as well as problem-aware personality and solution oriented attitude
- Excellent analytical and teamwork skills
- Knowledge of IT internal processes, authorization, documentation
- Having strong communication skills to work in harmony with internal stakeholders
- Good written and verbal communication skills in English
11. BS in Software Engineering with 6 Years of Experience
- Experience in Database Technologies
- Experience in cloud based Database Technologies - AWS RDS
- Demonstrated experience in Relational and NoSQL Database Technologies including Oracle, MySQL, and NoSQL
- Demonstrated experience with latest Oracle XML database releases
- Demonstrated Experience in Defining and Implementing Production Proactive Health Monitoring of the Database Technology
- Strong Incident Root Cause Analysis on Database Execution and Application Interaction with Database Technology
- Demonstrated Database Performance and Resource Tuning skills
- Service Oriented Architecture (SOA) Experience
- Demonstrated strong analytical skills
- Experience with implementing and managing Active / Passive Oracle Database Implementations
12. BA in Data Science with 6 Years of Experience
- Extensive MS SQL Server database experience with a passion to learn
- Heavy working experience managing and automating SQL Server with Powershell
- Strong decision-making skills, take charge personality, and the ability to drive a plan to completion.
- Ability to work flexible hours as required by business priorities.
- Strong verbal and written communication skills, and customer service.
- Advanced analytical and creative skills that demonstrate resourcefulness in problem solving and optimization of design.
- Ability to communicate information and issues clearly and succinctly with both technical and non-technical personnel.
- Self-manage work and complete systems and database related projects independently, on a team, and while leading a team.
13. BS in Network Administration with 9 Years of Experience
- Experience supporting Oracle, PostgreSQL and MySQL databases in an enterprise environment.
- Sound knowledge of Oracle, Goldengate, PostgreSQL and MySQL with the ability to transfer knowledge to other team members.
- Ability to Support RDBMS in both Linux and Windows environments.
- Experience in troubleshooting problems and forming a resolution with IT systems and individuals.
- Ability to interact with Customer SME's in a clear, concise, professional manner
- Able to make effective decisions in high-pressure situations, with limited management escalation.
- Exceptional written and verbal communication skills.
- Hands-on Vertica troubleshooting experience.
- Knowledge and Experience with Best Practices and Standards
- Excellent written and verbal communications Skills
- Experience with Hadoop, Mondrian, SQL, SSAS, and SSRS
14. BA in Systems Engineering with 11 Years of Experience
- Ability to troubleshoot client/server problems.
- Ability and proficiency in the use of computers and company standard software specific to position.
- General understanding of database administration.
- Basic knowledge of Oracle and/or SQL Server database management tools.
- Basic knowledge of SQL and PL/SQL, UNIX commands.
- Excellent oral and written communication skills.
- Ability to apply the principles of logical thinking to define problems, collect data, establish facts, and draw valid conclusions.
- Ability to comprehend the consequences of various problem situations and to make sound decisions or to refer problems to appropriate people for decision making.
- Ability to manage multiple projects and meet necessary deadlines.
- Ability to work varying hours, including evenings, weekends and holidays
- Ability to perform other assignments at locations outside the office.
15. BS in Cybersecurity with 5 Years of Experience
- Strong AWS fundamentals
- Strong hands-on DBA experience in a fast-paced environment
- Experience with highly available (HA) and disaster recovery (DR) implementations for AWS RDS, primarily PostgreSQL.
- Working knowledge of installing, configuring, designing, patching, archiving and monitoring of DBs along with monitoring and performance understanding.
- Working knowledge of data encryption, PII management and related tools
- Experience in an Agile environment
- Excellent communication and collaboration skills.
- AWS Security and remediation experience
- Experience with Snowflake
- Experience in a Leadership role
- Experience as a DBA
- Experience in building and maintaining software systems with AWS, GCP, or Azure
- Experience in building maintaining AWS RDS
- Proven ability to manage multiple projects at once with strong analytical experience pair with the ability to evangelize best practices
16. BA in Business Intelligence with 5 Years of Experience
- Strong working knowledge of databases
- Strong understanding of security standards and best practices
- In-depth knowledge of database management (Installation, creation of new instances, space management, database reorganization, backup and recovery, performance optimization, monitoring and troubleshooting, identification of bottlenecks in locks, waits)
- Strong understanding of database structures, theories, principles, and practices
- Hands-on database tuning and troubleshooting experience
- Strong knowledge of software development processes including agile processes and test driven development
- Strong understanding of DB architecture and providing technical leadership to large and complex systems
- Experience integrating vendor and open source products into an overall system
- Experience working on cloud hosted services like AWS
- Strong verbal and written communication skills
- Excellent trouble shooting skills
17. BS in Computer Science with 6 Years of Experience
- Familiarity with AWS database offerings
- Familiarity with MongoDB
- Experience with Oracle GoldenGate
- Strong Oracle core DBA experience
- Strong Oracle architecture knowledge
- Strong Oracle Performance Tuning Experience (Instance Tuning & SQL Tuning)
- Experience in oracle features - RAC, Data Gard, Compression, partitioning, analytical functions
- Experience in Multi-Tenant Databases
- Experience in User access reviews, security, and data encryption
- Experience in Oracle SQL/PLSQL
- Experience with Enterprise Manager for monitoring and administering mission critical databases
- Experience with database backup and recovery
- Experience with database patching and upgrades
- Experience in any scripting language such as Unix shell script (or) Perl script.
- Knowledge of database and SQL performance tuning and troubleshooting skills
- Experience with Redshift databases
- Knowledge of MySql databases.
18. BA in Information Technology with 7 Years of Experience
- Good Linux administration Skills and Shell scripting
- Proven working experience in working with developers to create databases, tables, SQL code, stored procedures and performing code reviews.
- Working experience with data platforms on AWS (Dynamo DB, Aurora etc. )
- Working experience with NoSQL DB (Cassandra, ElasticSearch etc.)
- Ability to work independently with minimal supervision and guidance.
- Familiarity with programming languages API
- Strong experience in index management, disk capacity management and database monitoring
- Good understanding of High Availability using SQL Cluster, Active-Active, Active-Passive and DR technologies using log shipping and Availability Group
- Oracle DB experience, Oracle RAC and ASM
- Experience in SQL, DB tooling
- Experience in working with Oracle in a Linux/Unix environment
- Experience in AWS and RDS
- Experience in vSphere /VMware environments
- Scripting experience (Bash, Python, etc.)
- Familiarity with CDC concepts and management
19. BS in Information Systems with 10 Years of Experience
- Ability to read, write, speak and understand English
- Knowledge of database architecture and its implementation
- Good knowledge of PL/SQL programming language
- Good knowledge of Instance, database and query tuning to improve the performance of the database/application
- Good understanding of Disaster Recovery (DR) methodologies
- Good understanding of SAN technologies related to disk layouts
- Good knowledge of Windows/Linux/AIX operating systems and shell scripting
- Good understanding of Change Management procedures
- Ability to communicate orally and in writing in a clear and straightforward manner
- Ability to communicate with all levels of management and company personnel
- Ability to handle multiple projects and tasks
- Ability to make decisions and solve problems while working under pressure
- Ability to prioritize and organize effectively
20. BA in Database Management with 8 Years of Experience
- Advanced knowledge of SQL optimization
- Experience implementing and maintaining best practices for database backups
- Basic Linux system administration experience
- Intermediate understanding of PostgreSQL database systems
- Virtualization experience, specifically AWS cloud computing and clustering
- Strong analytical and data-driven decision-making skills
- Ability to work within aggressive and dynamic timelines
- Strong communication skills and an ability to interact with all levels of end users and technical resources
- Experience managing infrastructure with code
- Sufficient knowledge of scripting languages such as Python or PHP for task automation and monitoring components
- Familiarity with the Atlassian Stack management tools (JIRA, Confluence, Bitbucket)
- Experience in data warehousing considered an asset
21. BS in Software Engineering with 6 Years of Experience
- Ability to articulate ideas verbally and in the written form
- Well-developed problem-solving, and root cause analysis skills
- Sound analytical and creative mind, and be able to work under pressure
- Working experience in the IT field
- Experience managing a database team
- Experience in large-scale database patching/upgrade/migration
- Experience in hybrid cloud-based/on-premises database operation
- Experience working with Relational Database management systems including DB2 and/or SQL Server.
- Experience in implementing and managing DB2, SQL Server, and other databases
- Experience in DBMS architecture
- Experience in: data modeling and database design multi-tiered application architectures system architecture (e.g., Linux, Unix, Windows) optimal methods of manipulating required data object oriented programming and script writing
- Knowledge of data replication techniques and processes, and cloud computing platforms (e.g., SaaS, IaaS or PaaS)
- Experience working in an Agile environment
- IBM DB2 and Microsoft SQL Server certifications
- Experience working in DB2 LUW (Linux, Unix, Windows)
22. BA in Data Science with 5 Years of Experience
- Experience with the configuration, deployment, and operation and maintenance of Microsoft Desktop operating systems.
- Advanced level skills in Microsoft Office software suite - Word, Excel, Outlook, PowerPoint
- Ability to communicate effectively with all levels of employees and outside contacts
- Strong interpersonal skills and good judgment with the ability to work alone or as part of a team
- Experience in MSSQL Database administration using SQL Server 2012/2014/2016/2017/2019 versions.
- Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster, AlwaysOn and various replication technologies
- Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
- Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
- Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
- Ability to develop procedure documents and maintain detailed database related documents.
- Able to organize work efficiently and work well under stress, changing priorities, and time constraints
- Expertise in MySQL/PostgreSQL/MongoDB with Linux environment including Backup, replication Configuration for DR purpose.
- Familiarity with compliance guidelines like SOC II, FINRA and best practices like ITIL, Change/Incident Management
- Expertise in cloud platform like AWS, Azure, etc
23. BS in Network Administration with 6 Years of Experience
- IT experience including hands-on experience as an Oracle DBA supporting critical business applications
- Experience in Oracle 12c or 19c RAC and multitenant database support
- Expertise in database performance tuning, query optimization, and assist application teams in solving and resolving database and SQL performance related issues
- Experience in developing tools, standards, governance polices to ensure efficient, effective, and compliant delivery of database capabilities
- Experience in deploying database schema management and implement database configuration changes in production.
- Hands-on experience deploying and supporting databases in the Cloud(AWS/Azure)
- Expertise developing CI/CD pipelines for database infrastructure/DDL/DML using tools including Jenkins, Jenkins Core, Stash, Artifactory, uDeploy, Terraform, and Concourse, etc.
- Programming skills in Linux shell scripting, PL/SQL, Python
- Deep technical design and analysis skill
- Ability to take care of ambiguity and work in fast paced environment
- Deep experience supporting important applications quickly
- Superb communication skills, both through written and verbal channels
- Strong collaboration skills to work with multiple teams in the organization
- Ability to understand and adapt to changing business priorities and technology advancements
- Strong knowledge and technology trends in implementing business applications
- Proven teammate and able to mentor junior team members
- Strategic thinking and critical problem-solving skills
24. BA in Systems Engineering with 3 Years of Experience
- Experience as an AWS database administrator
- Excellent knowledge of AWS Databases such as RDS, RedShift, Aurora and PostgreSQL or experience with equivalent platform and a willingness to adapt to AWS
- Strong programming skills in SQL
- Strong problem solving and documentation ethos
- Good communication skills to communicate from technical to user levels.
- Excellent analytical and organization skills
- Ability to work independently, prioritise work and know when to seek guidance.
- Flexible attitude and ability to perform well under pressure.
- High attention to detail alongside great time management.
- Ability to interpret both technical and non-technical requirements.
- Sound knowledge of traditional as well as agile software development methodologies
- Knowledge of Scrum methodology of agile software development and its application
- Good knowledge of AWS services
- Experience in the commercial insurance industry
- Knowledge of Snowflake, or similar data cloud technology
- Experience working with Microsoft’s .Net Framework, Java, Visual Studio, HTML5, JavaScript frameworks, and J2EE
25. BS in Cybersecurity with 3 Years of Experience
- Ability to work closely with Database engineers to implement standards, policies and procedures developed.
- Ability to document and develop standard operating procedures for day to day activities.
- Ability to make technical recommendations. Demonstrated high level of competency in SQL Server database administration.
- Thorough knowledge of and ability to use SQL Server database utilities and management tools.
- Thorough knowledge of SQL and PowerShell programming.
- Ability to establish work flows, manage multiple projects, and meet necessary deadlines.
- Advanced knowledge of communication layer between client, network and SQL Server databases.
- Advanced knowledge of and demonstrated competency in all facets of SQL Server database administration.
- Familiarity with Data Warehousing and Data Cubes
- Full understanding of the software development life cycle and direct experience working through an entire software cycle
- Excellent communication skills
26. BA in Business Intelligence with 6 Years of Experience
- Experienced in configuration, security, failover, and optimization of databases in high availability environment.
- Experience with various business process and system modeling tools including: Data Flow Diagrams, Process Models, ER Diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process Decomposition and Use Case Scenarios.
- Hands-on experience with DB2 with HADR installations, upgrades, configuration, tuning, index creation and performance analysis.
- Experience in planning and implementing fault tolerant and high availability systems.
- Hands-on experience implementing and configuring packaged real-time monitoring and alerting solutions.
- Experience with other performance monitors
- Hands-on experience with automation of tools, implementations, scripting and database reporting metrics and reports.
- Heavy SQL experience writing complicated queries from scratch, tuning other’s code, analyzing impacts.
- Experience with SAN storage systems.
- Expertise in backup/recovery/fail-over methods and best practices.
- Excellent written and verbal communication skills.
- Ability to write clear documentation of operating procedures, and ability to write detailed specifications.
- Must have a “can-do” attitude, work well in a cross-functional environment, must be able to work well without supervision and lead others.
- Self-starter, quick learner and great team player.
- Possess the ability to prioritize competing priorities and work in a cross-matrix management organization.
27. BS in Cybersecurity with 6 Years of Experience
- IT experience.
- Experience in working with Oracle database technologies.
- Experience in supporting some of the following technologies Oracle SSO, OIM, OBIEE, Data Guard, Oracle RAC, ASM, and Sun Cluster on Linux and Solaris systems.
- Strong knowledge of the entire Oracle database and Oracle Applications environment and architecture.
- Strong technical expertise and functional exposure to Oracle Databases version 12C/19C (12.2 preferred)
- Experience in working with customers to build and formulate business requirements.
- Experience in developing documentation, white papers and presentations suitable for peers and immediate management.
- Experience providing advanced Database and Application server administration support to a mission production environment and development.
- Database and Application server troubleshooting, installation, upgrade, performance tuning, development support, scripting and producing documentation.
- Experience as DBA in a Windows and/or Linux OS environment using RDBMS (required) and/or NOSQL/Non-relational databases
- Familiarity or background in software development using mainstream programming or scripting languages
28. BA in Database Management with 8 Years of Experience
- Experience with Microsoft SQL Server capturing stakeholder and business requirements, designing, engineering, implementing, securing, and operating and maintaining vendor currently supported enterprise-level Microsoft SQL Server DB solutions (SQL Server 2012 and newer) across an IT multiplatform (Microsoft, *nix etc.) enterprise information systems (LAN, MAN, WAN, etc.).
- Experience operating and maintaining solutions in secure processing environments which must adhere to Government Information Assurance and Security standards such as the Defense Information Systems Agency (DISA) Security Technical Implementation Guides (STIGs).
- Demonstrated experience implementing, maintaining, testing, and validating Microsoft SQL Server High Availability (HA) technologies and concepts, such as Basic and Always-on Availability Groups (BAG/AAGs), to maximize the availability, resiliency, reliability, and fault tolerance of product DB environments.
- Demonstrated experience designing, implementing, maintaining, testing, and validating Microsoft SQL Server Disaster Recovery (DR) solutions, built on technologies and concepts such as log shipping and stretched AAGs, to ensure both local and off-site recovery capabilities within established Recovery Time and Point Objectives (RTO/RPOs).
- Demonstrated experience leveraging vendor provided best practices, systems, applications, and services to regularly patch and upgrade deployed Microsoft SQL Server implementations to maintain compliance and configuration requirements, minimizing, and eliminating if possible, production and end-user impact and/or downtime.
- Demonstrated experience authoring, testing, troubleshooting, and implementing scripted technologies, such as Microsoft PowerShell, PowerShell on Linux, Bash, T/SQL, etc., to automate and orchestrate routine, as well as complex, DBA duties and responsibilities, with a focus on maximizing efficiency, consistency, and minimizing the subsequent human error factor of related tasks.
- Experience in Database Design, Development and Administration of MS SQL Server 2012/2014/2016/2019 in Production, Development and QA environments.
- Experience in a modern software development environment that is Agile and incorporates DevOps practices.
- Strong foundation in security, having executed security audits and remediating findings.
- Experience with object-oriented and/or functional programming and programming languages.
- Experience with MS SQL 2016 and MS SQL 2019.