Database Administrator

SUMMARY

The Database Administrator acts as a technical liaison to business units, vendors and consultants to ensure efficient design and consumption of SQL resources. The position manages, maintains, and monitors all aspects of the Enterprise SQL Servers and instances including but not limited to, Disaster Recovery, Maintenance, Developing ETL Processes, Integrating 3rd party data sources, Performance tuning, and support end user database related issues.

ESSENTIAL FUNCTIONS

• Create excellent service experiences that promote the Veridian brand.
• Maintains and applies up to date, specialist knowledge of database concepts, object and data modelling techniques and design principles, and a detailed knowledge of the full range of database architectures, software and facilities available.
• Responsible for implementing physical database changes.
• Administer and maintain SQL database cluster and Microsoft clustering environment systems to offer the highest reliability and performance possible.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
• Set up alerts to proactively recognize SQL performance issues and to minimize false alarms.
• Create and maintain routine DB Maintenance functions such as table indexing, views, backups, SQL Server log reviews/error corrections, database creation and changes and scheduled replication of databases.
• Develop and maintain Azure Data Warehouse utilizing Data Lake, Databricks, and Azure DataFactory.
• Administer and maintain log ship, database mirroring, high availability databases at DR location and conduct regularly documented tests to confirm we have Business Continuity Procedures in place and that they work as needed.
• Monitors database activity and resource usage to prevent bottlenecks and contention before it occurs.
• Create and maintain procedures and documentation for all aspects of database and SQL server administration in a highly secured enterprise environment adhering to PCI regulatory standards.
• Evaluate new SQL Server features to optimize efficiency and query execution plans.
• Implement and maintain Business Intelligence software and hardware, and other applications as appropriate for on demand report generation, scheduling and delivery.
• Support Business/Data Analysts and their projects by developing processes and objects that align with standards and best practices as well as aid with problematic queries.
• Design custom reports as requested by management staff using SSRS, Crystal Reports, Business Objects, and or other methods.
• Work with third party vendors and other internal department staff on any application using SQL or other complex database structures or database connections.
• Develop SQL Server Integration Services (SSIS) packages to automate processes and manage production data files.
• Perform basic PowerShell and Command line scripting.
• Assist with administration of Oracle services including application integrations, SQL scripting, patching, user administration, and installing Oracle Prod DML updates using internal Change Management processes.
• Assist Core with DNA core financial system upgrades.
• Implement and administer Business Intelligence software (Power BI, Business Objects, SSAS, SSRS) and hardware, and other applications as appropriate for on demand report generation, scheduling and delivery.
• Assist with maintaining the enterprise data warehouse structures and look for new sources of data to expand the business intelligence reporting capabilities.
• Communicate database changes to affected parties and document changes.
• Administer and maintain third party data warehouse application Data Librarian.
• Develop and manage ETL processes using Intellectual Dimensions Data Librarian and SSIS packages.
• Assist with developing and maintaining a security scheme for the database environment, as well as assisting in disaster recovery, while maintaining data integrity.
• Allocating system storage and planning future storage requirements for the database systems.
• Look beyond the present environment and day to day processes and advise on what is best for the credit union s data in the long term.
• Contribute positively to team effort by consistently achieving established goals and expectations.
• On call availability required for system support as needed (includes nights and weekends).

KEY ATTRIBUTES

• Oral and written communication skills.
• Member service focus.
• Attention to detail and accuracy.
• Positive attitude that supports a team environment.
• Dependable and punctual; flexible during peak times.
• High level of confidentiality.
• Organizational skills.
• Self-motivated; ability to work without close supervision.
• Problem solving; analysis.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job:

• Frequently lift and/or move items over 50 pounds.
• Remain sedentary (seated) for extended periods of time.
• Regularly stand, walk, bend, kneel, stoop, crouch, crawl and climb.

WORKING CONDITIONS

This job operates in a professional office environment and routinely uses standard office equipment. While performing the duties of this job, the employee is required to work both inside and outside in hot/cold, wet/humid, and dry conditions. The employee may also be exposed to fumes, airborne particles, and moving mechanical parts. Work in confined spaces and on ladders/scaffolds is often required.

TRAVEL

Limited travel expected.

REQUIRED EDUCATION AND EXPERIENCE

• Bachelor's Degree in Management Information Systems, Computer Science or related field or equivalent combination of education, training, and experience of 8+ years.
• Fluent computer skills in a Microsoft environment.
• 2+ years of progressive work experience with Microsoft SQL Server, including the following experience:
  • Database theory and database design.
  • Failover clustering, high availability groups, SAN replication, and other high availability technologies.
  • Business intelligence reporting.
  • Microsoft Active Directory.
• 2+ years of experience in troubleshooting and resolving database problems.

PREFERRED EDUCATION AND EXPERIENCE

• Microsoft SQL Server Certification.

OTHER DUTIES

Veridian Credit Union is a PCI compliant financial institution to ensure the security of member information. As such, all employees are expected to ensure security measures are in place and adhered to regarding PCI and other highly secure data compliance requirements.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

ABOUT VERIDIAN

Veridian Credit Union provides equal employment opportunities to all employees and applicants for employment without regard to age, race, creed, color, sex, pregnancy, sexual orientation, gender identity, military service, national origin, religion, physical or mental disability, genetic information, or any other classifications protected by applicable federal, state or local laws.