Senior Database Administrator(Big Data)

POSITION SUMMARY : Performs and plans management and administration of technology in area of specialty. Works with team members to ensure technology is effectively supporting enterprise systems. Shares knowledge and provides mentoring to other IT associates.

ESSENTIAL FUNCTIONS :

Analyze existing database systems and recommend improvements

Work with IT Manager to establish database security structures, Sox compliance

Manage and maintain Cloudera Data Platform (CDP) clusters, ensuring high availability and performance.

Administer and monitor Apache Kafka (open-source) clusters, including topic management, performance tuning, and security.

Perform database administration for Oracle, MySQL, and PostgreSQL systems, including backup, recovery, and performance tuning.

Develop and maintain automation scripts using Shell scripting and Ansible for deployment, monitoring, and configuration management.

Collaborate with data engineers and developers to optimize data pipelines and ensure data integrity across platforms.

Implement and maintain security best practices across all data platforms.

Troubleshoot and resolve issues across the data stack in a timely manner.

Fix ongoing issues, act as an individual contributor, and take full ownership of the environment.

Create and maintain database access systems including tables, indexes, views, stored procedures, and triggers

Administer database replication between servers, across Local Area Network and Wide Area Network

Tune and optimize database objects

Provide 24x7 on call support

Provides technical input to solution development plans and concept documents

Demonstrates understanding of business impacts of issues and how they relate to IT owned solutions

Communicates effectively in written and verbal form in a cross-functional setting with business partners

Shares knowledge and actively mentors less experienced IT Administrators (Administrator 1 & 2)

Performs and plans major version upgrades

Design and implement effective monitoring of enterprise systems

Tunes systems using experience and deep knowledge of area

Foresees risks and communicates and mitigates those before problems arise

Documents technical designs and procedures for team library

Plans and manages technical projects involving other teams

Communicates technology effectively to non-technical associates and management

Recognizes and understands technology impacts within the business

Contributes to technical research on new technologies, processes or procedures with a desire to continuously learn new technologies

OTHER RESPONSIBILITIES :

Participates in project definition activities including estimation of delivery

Perform other duties as necessary

EDUCATION EXPERIENCE AND SKILLS REQUIRED :

Bachelor of Science Degree in Computer Science, Information Technology, Management Information Systems, Business or another relevant field AND a minimum of 6 years relevant experience OR equivalent combination of education and relevant experience

Outstanding academics with the demonstrated ability to apply learned knowledge

Fluency in English is required

Experience with Relational or NoSQL database technologies

Demonstrated ability to implement new technologies effectively

Demonstrated strong and effective verbal, written, and interpersonal communication skills in a small team setting

Consistently demonstrates quality and effectiveness in work documentation and organization

Experience with Big Data Technologies supporting a broad variety of solutions including HDFS, Kubernetes, Kafka, Elastic, SQL Server

DESIRABLE QUALIFICATIONS :

Superior academics

Previous experience working in a team environment