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 :

EDUCATION EXPERIENCE AND SKILLS REQUIRED :

DESIRABLE QUALIFICATIONS :