Database Administrator - ON SITE

Are you looking to have a positive impact on people in your community? Connex Credit Union is looking for diverse talent who are motivated to improve the financial well-being of others. We’re a company with a long and successful history where trust is important and exceptional customer service is the standard. We are committed to our employees, our members, and the communities we serve. If you want to make a difference and be part of a growing, inclusive organization, join us in our mission.

Benefits:

• Competitive compensation.
• Medical, Dental, and Vision coverage.
• Paid time off.
• 401K contributory plan with company match.
• The opportunity to become involved in community outreach.

Responsible for the on-going enhancement and maintenance of an enterprise reporting database including report building and ad hoc querying.  Evaluates business reporting needs, develops a data structure to support business needs, evaluates available data including external files, and maps data into a structure suitable for the designed solution.  Builds, maintains, and monitors daily/weekly/monthly import processes (using SSIS or other technologies).  Documents and updates data warehouse mappings.  Implements security measures to ensure proper database security.  Acts as a cross-trainer and backup to other areas of the IT department.

Essential Functions and Responsibilities:

• Identifying data sources, developing a database schema, mapping files into the schema, integrating data through ETL processes, monitoring daily loads, documenting the data flow, and ensuring database security.
• Performs ad hoc queries, stored procedures for developers, and develops standard reports for business users.
• Create and modify databases, products and reports according to client needs and functional requirements.
• Maintain the integrity and availability of databases, as well as troubleshooting database issues and implementing data backup and recovery mechanisms.
• Design, develop and manage relational databases for optimal performance and data security.
• Use advanced SQL skills to create and write reports in support of analytics.
• Performs other duties as assigned.

Performance Measurements (if applicable):

1. Establishes reasonable time frames for completion of all projects and completes projects within that timeframe.
2. Ensures clean audits or audit resolutions within departmental service metrics.
3. Maintains and ensures data integrity.
4. Ensures clean annual disaster recovery testing and responds to disasters according to departmental service metrics.
5. Anticipates data needs and security requirements.

Qualifications and Requirements:

• Experience:  Three to Five years of similar or related experience.
• Education:  Appropriate industry experience or a (B.S. or M.S.) in Computer Science or Computer Engineering.

Technical Skills:

• SQL Proficiency: Mastery of SQL for querying and managing databases.
• Database Design: Understanding of database schema design, normalization, and indexing.
• Database Management Systems (DBMS): Experience with systems like MySQL, PostgreSQL, SQL Server, and SQL Server Integration Services (SSIS).
• Data Modeling: Ability to create data models that support business processes.
• Performance Tuning: Skills in optimizing database performance and troubleshooting issues.
• Reporting: Leverage SQL skills and reporting tools such as CRMBI in creating, writing, and optimizing reports to enable and support business needs.
• Backup and Recovery: Knowledge of data backup, recovery, and disaster recovery planning.
• ETL Processes: Experience with Extract, Transform, Load (ETL) processes for data integration.
• Security: Understanding of database security practices to protect data integrity and privacy.

Soft Skills:

• • Problem-Solving: Ability to discuss, troubleshoot and solve complex issues efficiently and effectively.
  • Attention to Detail: Precision in managing and manipulating data.
  • Communication: Clear communication with team members and stakeholders to understand requirements and explain solutions.
  • Analytical Thinking: Strong analytical skills to interpret data and make informed decisions.
  • Team Collaboration: Ability to work well in a team environment, often collaborating with developers, analysts, and other IT professionals.

Additional Skills:

• Project Management: Basic understanding of project management principles.
• Adaptability: Willingness to learn new technologies and adapt to changing requirements.
• Documentation: Ability to document database structures, processes, and procedures clearly.
• Interpersonal Skills:  A significant level of trust and diplomacy is required, in addition to normal courtesy and tact.  The ability to motivate or influence others is a material part of the job requiring diplomacy and trust.

Other Skills:         

• Experience with relational databases.
• Experience with financial systems is preferred.
• Knowledge of office / business software including Microsoft Office, Exchange and banking products.
• Ability to solve complex analytical or project related problems.

Physical Requirements:  Lifting boxes up to 20 lbs.

Work Environment:  On call after hours.