DBA Functions:

• Perform monitoring of database instances across 4 environments.
• Schedule jobs to automate backup, health monitoring, disk space and backup verification.
• Implement security for servers, databases, objects, and users.
• Plan and execute database backup & recovery.
• Implement and manage database backup and disaster recovery procedures.
• Design and develop relational databases, tables, relationships, indexes, & stored procedures.
• Anonymize personally identifiable information (PII) data across environments (Prod to UAT).
• Maintain database source code according to configuration management best practices.
• Manage data and schema migrations across our 4 environments.
• Perform data migrations by designing and develop extract, transform, and load T-SQL scripts.
• Extract data into text file formats such as CSV.
• Design, implement and execute SQL Server Reporting Services (SSRS) reports.
• Provide database support to software application developers.
• Provide support for data Integrations and data migration processes.
• Provide support during outages incident bridge engagement, incident handling, resolving, and restoring application/database functionality as quickly as possible.
• Support database upgrades.

DBA Requirements:

• Bachelor’s degree in Information Technology, Computer Science, or related discipline
• 4 years prior work experience in a similar role.
• Hands-on database design, development, and administration experience.
• Experience working as part of an Agile scrum team.
• Must be eligible for a TS clearance.
• Microsoft SQL Server.
• SQL Server Management Studio (SSMS).
• SQL Server Reporting Services (SSRS).
• Structured Query Language (SQL).
• Transact-SQL (T-SQL).
• Exceptional verbal and written English communication skills.
• JIRA or similar.
• Confluence or similar.
• Microsoft Office.
• CompTIA Security+ Certification preferred.

Database Administrator Duties and Responsibilities:

• Maintain database and data warehouse systems, including monitoring and troubleshooting
• Design and support the enterprise data warehouse
• Collect, process and transform data from current and future data sources for consumption and visualization by various business units
• Oversee and conduct the conversion of data into insights that will lead to informed business decisions
• Shape data infrastructure, inclusive of data-warehousing, reporting, and analytics platforms
• Extract data from MySQL, Maria, MS SQL and other databases and load into Redshift
• Create Redshift clusters from scratch, manage and tune their ongoing operation
• Process flat files, pull data from AWS, S3 and other sources
• Configure and support ETL tools that will be used to transform data
• Tune the data warehouse for timely insights via business intelligence (BI) tools
• Document and create technical diagrams for solutions
• Databases (Redshift) setup, administration and troubleshooting
• Analytics tools (Tableau) setup, administration, and troubleshooting
• MySQL installation, administration, troubleshooting and security
• SQL query writing and optimization
• Database and analytics tool maintenance
• Data file maintenance including backup and recovery
• Server performance monitoring and tuning
• Data design (schema design)
• Integration of MySQL with analytics databases and tools (such as Redshift, Tableau, etc.)

Database Administrator Skills, Experience, Qualifications:

• NoSQL database experience
• Cloud native database experience
• Experience in high-performance transactional environments
• Expert SQL skills and knowledge of MySQL database
• Strong knowledge of AWS Relational Database Service (RDS) and Amazon Redshift
• Knowledge of ETL tools that can integrate with RDS and Redshift technologies (AWS Glue or related ETL tools)
• Familiarity with AWS Data Pipeline, Kinesis, S3 and Redshift Spectrum
• Bachelor's degree in computer science, information systems or related field
• Three or more years of experience in medium to large IT environment, working with database technologies including a minimum of 1 year in AWS database technologies
• AWS Big Data Specialty certification or other AWS certification desired,
• Knowledge of the Atlassian Jira products a plus

Database Administrator Roles and Responsibilities:

• Entering and reviewing data loaded into the data warehouse for accuracy and completeness
• Responsible for the development, maintenance, and support of complex enterprise data warehouse system and corresponding data marts
• Troubleshooting and fine tuning complex data warehouse applications by conducting research into new data warehouse applications and determining viability for adoption
• Establishing development standards, evaluating existing subject areas stored in the data warehouse and incorporating existing subject areas into an enterprise model
• Creating new or enhanced components of the data warehouse
• Responsible for keeping the ERDC Data Warehouse updated and providing reports for users and customers to view the data to track and manage funds by projects
• Responsible for correcting the error or complete the request in a development environment
• Responsible for troubleshooting the ERDC Data Warehouse to determine if data errors are in the Oracle database or application errors in WebFOCUS, our reporting software

Database Administrator Skills, Experience, Qualifications:

• BA/S in Database Administration, Computer Science, Information Technology, Software Engineering
• Database administration experience in a professional environment
• Experience with Database Management Systems (DBMS) technology, specifically Oracle and SQL Server is desired
• Must have experience with programming languages such as C#, JavaScript, Python and VB.NET
• A CompTIA Security+ certificate may be required prior to starting this position
• Intermediate to 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

Responsibilities for Database Administrator :

• Provide design, maintenance, and database support for company applications, from both vendors and in-house.
• Perform traditional database administration duties including, but not limited to, software installation, database creation, database maintenance, capacity planning, tuning, backup, and business continuity planning for multiple high-availability databases.
• Support, prioritize, and troubleshoot database, operating system, application and hardware issues.
• Diagnose problems and implement corrective actions related to database management and associated applications.
• Create, test and maintain documentation, including diagrams and schemas, of applications, including standards and procedures for operational and technical purposes.
• Create, maintain and modify simple to complex reports.
• Candidates must think on their feet and use their initiative to solve problems and deliver solutions
• Excellent customer relations, communication, presentation and organization skills of utmost importance
• Able to change direction and work on multiple project aspects at once
• Enthusiastic, passionate, able to enthuse and motivate others
• Leadership ability and behavior consistent with Virgin Hotels Core Values: Fun, innovative, original and personable, and striving to deliver high quality and brilliant customer service

Qualifications for Database Administrator:

• Bachelor's or Associate's Degree in Computer Science or related field, or equivalent experience.
• Highly motivated to work both independently and with cross functional teams.
• Detail oriented with strong analytical skills.
• Comprehensive knowledge of Microsoft SQL server system administration and database design obtained by five to six years of experience performing the same.
• Comprehensive knowledge of software development, including SLDC, object-oriented programming, and event-driven programming
• Proficiency in Visual Studio, Visual C#, HTML, CSS, XML, JSON and JavaScript
• Ability to develop and maintain in-house software applications using programming languages such as T-SQL, C#, as well as web technologies such as HTML, XML, JSON, CSS, and JavaScript
• Ability to develop software that communicate with Active Directory to read and write user permissions
• Ability to develop software that uses ORM technologies like NHibernate
• Ability to debug software application using IDEs in Visual Studio
• Ability to deploy web application software to IIS web servers in a test and live production environment.
• Ability to create desktop application installer files
• Ability to deploy desktop application software to remote computers

Database Administrator Functions:

• Providing technical leadership and architectural direction for all database operations.
• Creating standard procedures and practices relating to databases and database management, while developing solutions for addressing gaps and identifying automation opportunities in the process.
• Collaborating, coordinating and cohesively working with Database architects and Business Intelligence teams to support enterprise applications and deliverable's.
• Facilitates server-side database development and client-side performance tuning when needed including index and DB I/O performance tuning and Stored Procedures.
• Conducting MSSQL Server and Server Updates
• Leading query optimization, tuning, analyzing and troubleshooting interactions between databases, operating systems and applications with regards to performance and resources usage.
• Creating, managing and modifying database tables, indexes, and data constraints.
• Managing database security across all database environments.
• Moderate to Advanced experience in some combination of the following areas: SQL Clustering, Strong Transact-SQL & PL-SQL, Advance knowledge of information systems project management methods and procedures. 
• Replication, Performance Tuning, Backup and recovery methods, Log shipping, Database Mirroring, Database capacity planning, and Users and Role creation and monitoring.
• Advanced knowledge and experience with multi-dimensional systems (eg: Oracle ESSBASE, HYPERION planning, SAP BPC, etc.) - MOLAP concept understanding.

Database Administrator Experience & Capabilities:

• Experienced in large landscapes/environments with multiple databases.
• Excellent communication skills, with a practiced ability to act independently and confidentially with little or no supervision;
• Ability to distinguish and manage confidential information, materials and conversations;
• Ability to effectively communicate verbally and in writing;
• Ability to establish and maintain effective working relationships in a diverse environment
• Ability to use and maintain source control
• Familiar with hyperconverged host environments and designing configuration of production class database servers and database disk requirements.
• Ability to create database implementation project plans and identify critical paths and resolve issues related to such.
• Provide progress reports to senior IT management as required.

DBA Administrator Roles:

• Manage day to day issues with globally distributed databases
• Work with the Development teams to design and support our platform as a whole
• Project-based work including new product deployments, configuration and deployment automation, testing, exploring alternative tools to incorporate into the environment, etc.
• Rolling out major changes and providing Tier 2/3 support during maintenance windows
• Documentation of designs and procedures.
• Represent the database systems and services in the development and execution of a disaster recovery protocol.
• Schedule and perform regular server/database maintenance and upgrades.
• Create better control and testing environments for application and development work.
• Monitor query performance and statistics to enhance speed and reliability of all Gopher applications.
• Clean up obsolete databases, tables, stored procedures, schemas, roles and users that are no longer active.

DBA Administrator Qualifications:

• Bachelor degree, college or equivalent work experience
• Expert-level familiarity with MySQL
• Intermediate-level familiarity with Postgres
• Operational experience with AWS
• Advanced scripting experience required (e.g. bash, perl, python, ruby)
• Strong written and verbal communication skills
• Excellent analytic and troubleshooting skills for problems that span multiple domains (applications, network, system)
• Hands-on experience with RDS and AWS Aurora
• Experience with Chef and Terraform
• Experience building and supporting high performance / high availability platforms
• Experience with monitoring tools (e.g. Nagios, Splunk, CloudWatch, Percona and Prometheus)

Database Administrator Roles:

• Create, configure, size and maintain our plan databases with high availability.
• Perform overall health checks and maintenance tasks such as indexing, performance tuning, backup/recovery, partitioning and patching at regular intervals.
• Develop monitoring, processes/procedures/standards that will continually improve the operation of the environment.
• Diagnose ETL and database-related issues, perform root cause analysis, and recommend corrective actions to management.
• Work with analysts and data engineers to support the design, development, implementation, monitoring, and maintenance of new programs and systems.
• Effectively communicate technical issues and proposed solutions to key management staff.
• Triage and help troubleshoot problems, downtime, and alerts.
• Collaboratively set the direction with the Data Integration Team, clearly establishing objectives that are aligned with Clover's company-level goals.
• Foster a healthy, results-oriented, and inter-disciplinary culture that is the bedrock of strong teams.
• Simplify the process by automating the delivery pipeline and database changes.
• Be the team expert in database/data warehouse performance and operational management across a variety of technologies including Relational and non-relational DBs including Postgres, CloudSQL, BigTable, and BigQuery.

Database Administrator Education and Experience:

• You have a minimum of 5+ years of experience maintaining high availability systems, supported by processes, procedures and standards that ensure data governance. Health care experience is a plus.
• You have experience with linux system administration and containerized applications or container based deployment.
• You have working knowledge of Security first principles and best practices: Least Privilege, Compartmentalization/Isolation, Attack Surface, Authentication/Authorization basics, Symmetric and Asymmetric Encryption.
• Great team players with the ability create excellent working relationships across the group. Collaborative approach with all departments
• Ability to break down barriers and resolving potential conflicts swiftly and effortlessly
• Strong communication and presentation skills to all levels of management
• Creativity and innovation are essential!
• Ability to think outside the box and approach all issues with a completely fresh approach
• Ability to anticipate needs and over deliver wherever possible
• Expert with databases and query language.

Roles for Database Administrator:

• Administration of geological databases and database-related activities.
  
• Develop and maintain geological database software, systems, procedures and standards.
• Managing software system licences, optimisation of existing data software and evaluation of new software solutions.
• Assess user requirements across the organisation and plan, develop, configure and maintain geological databases and their accompanying documentation and protocols
• Ensuring the integrity, security and accessibility of any collected data.
• Applying geological knowledge to database administration
• Management of database providers (Datashed) and contractors.
• Mentoring and troubleshooting for geology and other staff on database related tasks.
• Assist with generating JORC compliant datasets

Requirements for Database Administrator:

• The successful candidate will be able to meet the following selection criteria:
• Formal qualifications in Information Technology
• Excellent database management proficiency with
• MS SQL Server
• Visual Studio / SSIS
• Datashed
• A relevant bachelor degree (desirable)
• A background in mining and exploration practices
• Knowledge of the JORC Code as relating to data reporting standards and submissions
• Experience with working on interdisciplinary teams

DBA Administrator Duties:

• Manage databases (Azure SQL, Postgres, MySQL, Mongo) in Production/QA/Dev environments including installation, configuration, upgrades, schema changes, etc.
• Provide best practices on design, availability, replication, security, audit, and backup/recovery methodologies. Continuously re-evaluate the infrastructure for opportunities for optimization
• Troubleshoot database issues and maintain database systems availability and scalability within production environments
• Perform capacity-planning exercises to properly identify required hardware, software, database configuration/architecture necessary to support application needs
• Support multiple Scrum teams to produce quality deliverables and meet deadlines, while effectively managing priorities and communicating progress
• Part of on-call rotation to respond to and resolve application issues to ensure production applications are online

DBA Administrator Knowledge, Skills and Experience:

• Experience (2-3 years or more) managing production database systems, preferably in a SaaS environment.
• Understanding of database packaged releases, patching strategy, and enforcing standards via tools and automation
• Experience in Analytics/BI/Data Warehouse, specifically Power BI/Azure Data Factory is a plus
• Ability to develop procedures, processes and conventions to standardize database operations
• Understanding of RDBMS security administration
• Experience in scripting languages of your choice (PowerShell, Python, etc.) for monitoring and custom automation preferred
• Experience working with source code management tools (Git)
• Understanding of automated configuration management (Ansible, Terraform)
• Experience with Cloud-based systems or Virtual environments (AWS, Azure, Google Cloud)
• Familiar with working in a HIPAA-compliant environment and hw to design/ follow procedures as well as write documentation to maintain compliance preferred
• Previous Development/Operations experience a plus

Database Administrator Responsibilities:

• Develop conceptual and logical data models for USCG clients, mapping the structure of the current database assets.
  
• Collect and map Program Manager and Data Analyst user requirements to existing Access Databases
• Clean up and remove database tool components that do not trace back to program user requirements and needs.
• Decompose master databases into coherent functional smaller databases to reduce the overall load demands on the databases
• Develop a long-term database roadmap to help modernize processes and database assets to ensure long-term viability of all Program data processing needs.
• Develop user guides for existing and new databases
• Develop, implement and maintain new database solutions tailored to USCG client needs
• Full life cycle support of client's databases.
• Responsible for database backups, design, development, testing, and performance tuning.
• Responsible for the design and implementation of analytics solutions as needed
• Provide regular error reporting and perform regular data integrity checks
• Run regular reports and create client facing deliverables as needed
• Serve as SME when needed​

Database Administrator Skills, Abilities and Experience:

• Bachelor's degree is required. Master's degree or equivalent experience preferred
• Expert Knowledge of database programming and query troubleshooting.
• Experience with MS Access, with SQL, with VBA
• Experience in Database Architecture
• Knowledge of Python or R is a plus
• Strong analytical and troubleshooting skills for complex database performance.
• Strong knowledge of database upgrade/migrations.
• Able to understand and meet needs of end users.
• Good written and oral communication and soft skills.
• Able to work with multiple projects in a dynamic, fast paced and often changing environment.​

Database Administrator Responsibilities:

• Establish and perform administrator functions such as database management, user management, and storage management using Microsoft SQL Server.
• Create and manage system configuration specifications, training manuals, and other internal system documentation.
• Create and manage database maintenance procedures.
• Create and manage database backup and restore procedures.
• Troubleshooting any issues; log and track identified issues until successfully resolved.
• Stay current with releases and new functionalities; communicate and manage upgrades, releases, and the change control process.
• Participate in and support Microsoft SQL Server efforts as a subject matter expert.
• Regular contact with IT Development and Network Operations teams.
• Occasional contact with outside vendors, third parties, and end-users.
• Regular overnight travel to other regional office location(s) once or twice a month.

Database Administrator Education and Experience:

• Bachelor’s degree in Computer Science or equivalent training/education/experience in lieu of degree will be considered.
• Experience with Microsoft SQL Server.
• Experience with troubleshooting performance of Microsoft SQL Server.
• Experience with Microsoft SQL Server high availability and disaster recovery technologies and concepts.
• Proficiency with T-SQL to manage and administer Microsoft SQL Server.
• Understanding of Microsoft SSIS, SSRS, and SSAS administration.
• Understanding of underlying operating system storage and networking.
• Basic understanding of business intelligence software platforms.
• Knowledge of cloud relational or non-relational data storage engines is preferred.

Database Administrator Roles:

• Drive the development of database systems architecture, design, and ongoing review of system configurations in collaboration with relevant team members.
• Plan and ensure that database systems and related security standards
• Review standards periodically with IT Management and implement changes as required.
• Perform advanced support such as performance tuning, replication and mirroring, database partitioning and warehousing.
• Proactively audit database accounts and access privileges to ensure compliance with credit unions' information security policies.
• Provide strategic guidance and direction on technology changes, enhancements, upgrades and EOL practices.
• Install, upgrade, configure, and support clustered and non-clustered database systems on various operating systems.
• Develop ongoing maintenance and health check planning to proactively provide health systems.
• Administration and maintenance of server hardware.
• Administration and maintenance of Microsoft SQL Server and Windows operating systems including scripting and debugging.
• Provide strategic guidance and direction on technology changes, enhancements, upgrades and EOL practices.
• Install, upgrade, configure, and support clustered and non-clustered database systems on various operating systems.
• Perform all necessary maintenance such as database backups, log shipping, job scheduling, and disaster recovery planning and testing.
• Perform advanced support such as performance tuning, replication and mirroring, database partitioning and warehousing.
• Review patches and maintenance releases for database systems and make appropriate recommendations based on priority and impact to the affected system.
• Develop, document and implement operation procedures and conduct/participate in training as required.
• Maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank security and anti-money laundering laws appropriate to the position.
• Participate in the "on-call" rotation.
• Effective oral and written communication skills required to train, direct, and evaluate staff, diagnose, correct and log computer projects and problems.

Database Administrator Qualifications:

• Experience in Information Technology in a database administrator role.
• Demonstrates exceptional knowledge with Microsoft Server operating systems.
• Demonstrates exceptional knowledge with Microsoft SQL and tools.
• Demonstrates strong knowledge with Microsoft Clustering and Mirroring.
• Demonstrates strong knowledge of enterprise-wide computing architectures and infrastructure practices spanning multiple operations systems and hardware platforms.
• Demonstrates strong knowledge with systems security practices.
• Prolonged sitting throughout the workday to accomplish tasks.