Job description
Database Administrator
Job Description
The Database Administrator will perform database performance analysis, tuning and maintenance to ensure continued data integrity and optimal performance. This role will manage and maintain the Data Lake and Data Warehouses as operated and used by the organization to include further development and methods to update or insert new data sources as well as monitor the security and usage within determined specifications. Works with business stakeholders to determine business needs and apply industry standards to all database solutions created.
Essential Functions:
➢ Identifies business intelligence and data requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
➢ Recommends solutions by defining database and data warehouse structures and processes and functional capabilities, database security, data back-up, and recovery specifications.
➢ Assist in the development and maintenance of a data lake and/or data warehouse and associated data marts.
➢ Provide Ad-hoc reporting using transaction SQL Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
➢ Coordinates with service providers and maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
➢ Prepares users by conducting training; providing information; resolving problems. Provides information by answering questions and requests.
➢ Overall administration of a variety of database systems including Microsoft SQL Server and others. This includes auditing, modifying and amending data in systems.
➢ Creating/Coding new database solutions based on a combination of predetermined specifications, individual experience, and industry best practices.
➢ Determine database structural requirements by working with business stakeholders, and identifying optimal database specifications.
➢ Assisting internal customers with retrieving data from company production systems whenever needed.
➢ Troubleshoot and correct issues as they arise; ensure the system is running smoothly.
➢ Gather business requirements, design enterprise solutions and implement solutions for end-to-end development
➢ Create, maintain, deploy and schedule SSIS packages using SQL server data studio, Management studio and third-party ETL tools
➢ Coordinates and collaborates with systems developers and vendors as needed
➢ Collaborate with the business to design Data Policy (access/sharing/alignment)
➢ Collaborate with the business to identify capabilities and values in data objects.
➢ Design data quality practice and standard policy.
➢ Performs other duties as assigned.
Supervisory Responsibilities:
(Scope of the person’s authority, including a list of jobs that report to this job).
➢ None
Essential Qualifications:
(To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the competencies (minimum knowledge, skill, and ability) required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions).
Education/Licensure/Certification: Bachelor’s degree in a computer science or other IT related field is required.
Required Knowledge: Must have working knowledge in data modeling and data warehouse and data lake technologies and solutions. Advanced level proficiency in Microsoft SQL Server (T-SQL/Replication/SSIS/OLAP etc.) Business Analyst experience is preferred but not required. Azure Fundamentals Certificate Required. Certified Azure Data engineer preferred.
Experience Required: 5+ years of related experience in managing or serving as a lead or primary Database Administrator of a small to medium-sized organization. 10 years of experience working with SQL Server 2012 through 2019. Experience using an IT Service Management tool for incident and request tracking. Experience with DBA productivity tools. Hands on experience with database performance tools (Toad, BMC, etc.,)
Skill and Ability: Detail-oriented with good interpersonal skills and the ability to work as an effective team member with a broad array of people from multiple departments. Very effective troubleshooting skills. Ability to learn new technology and software applications quickly without specialized training. High level of customer service skills, and ability to fluctuate technical communication level to suit user’s needs. Ability to analyze technical problems and provide logical and effective solutions. Ability to read, interpret, and apply technical information from resource manuals. Ability to communicate clearly and concisely both verbally and in writing. Ability to train end-users of varying backgrounds and degrees of specialized understanding. Ability to establish and maintain effective working relationships with those contacted in the course of work
Physical Demands/Work Environment:
(The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)
Finger Dexterity: Use primarily for writing, operating calculator, telephone, keyboard, and other office equipment.
Talking: To convey detailed or important instructions to employees, patients, and applicants.
Hearing: Ability to hear normal conversations and receive ordinary information.
Vision: Average, ordinary, visual acuity necessary to observe patients and work on a computer. Clear vision at 20 inches or less and distant vision at 20 feet or more.
Physical Strength: Sedentary work; sitting most of the time. Exerts up to 10 pounds of force occasionally.
Working Conditions:
(The working conditions described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)
➢ Ability to work in an open area with moderate everyday noise.
➢ On-call support rotational duties are expected.
Core Competencies:
➢ Approachability
➢ Change Management (IT)
➢ Communication (Oral)
➢ Ethics/Values/Integrity
➢ Influencing/Persuading
➢ Listening
➢ Problem Solving
➢ Creative Thinking
Mental Activities:
(The mental activities described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)
Reasoning Ability: Ability to resolve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret
➢ Gather business requirements, design enterprise solutions and implement solutions for end-to-end development
➢ Create, maintain, deploy and schedule SSIS packages using SQL server data studio, Management studio and third-party ETL tools
➢ Coordinates and collaborates with systems developers and vendors as needed
➢ Collaborate with the business to design Data Policy (access/sharing/alignment)
➢ Collaborate with the business to identify capabilities and values in data objects.
➢ Design data quality practice and standard policy.
➢ Performs other duties as assigned.
Supervisory Responsibilities:
(Scope of the person’s authority, including a list of jobs that report to this job).
➢ None
Essential Qualifications:
(To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the competencies (minimum knowledge, skill, and ability) required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions).
Education/Licensure/Certification: Bachelor’s degree in a computer science or other IT related field is required.
Required Knowledge: Must have working knowledge in data modeling and data warehouse and data lake technologies and solutions. Advanced level proficiency in Microsoft SQL Server (T-SQL/Replication/SSIS/OLAP etc.) Business Analyst experience is preferred but not required. Azure Fundamentals Certificate Required. Certified Azure Data engineer preferred.
Experience Required: 5+ years of related experience in managing or serving as a lead or primary Database Administrator of a small to medium-sized organization. 10 years of experience working with SQL Server 2012 through 2019. Experience using an IT Service Management tool for incident and request tracking. Experience with DBA productivity tools. Hands on experience with database performance tools (Toad, BMC, etc.,)
Skill and Ability: Detail-oriented with good interpersonal skills and the ability to work as an effective team member with a broad array of people from multiple departments. Very effective troubleshooting skills. Ability to learn new technology and software applications quickly without specialized training. High level of customer service skills, and ability to fluctuate technical communication level to suit user’s needs. Ability to analyze technical problems and provide logical and effective solutions. Ability to read, interpret, and apply technical information from resource manuals. Ability to communicate clearly and concisely both verbally and in writing. Ability to train end-users of varying backgrounds and degrees of specialized understanding. Ability to instructions furnished in written, oral, diagram or schedule form. Ability to maintain patient and treatment confidentiality.
Mathematics Ability: Basic mathematics (including statistics) skills required.
Language Ability: Ability to read, analyze and interpret technical documentation, tables, figures, technical procedures, and regulations applicable to the health care industry. Ability to write correspondence to IT management and end-users as well as participate in the development of procedure manuals and IT documentation. Ability to effectively present information and respond to questions from groups of customers
Job Type: Full-time
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
- 8 hour shift
Work Location: Remote
www.colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, www.colinoncars.com is the ideal place to find your next job.