Sybase Database Track Sr. Engineer

Description

Role:- Sybase and PostgreSQL Database Administrator (DBA)

Location :- Plano, TX

Work Mode :- 5 Days Onsite 24x7 Rotational Shifts also on Weekend

Shift Timing -Shift 1 (8 AM – 5 PM) - Onsite

Shift 2 (4 PM – 1 AM) - Onsite

Shift 3 (12 AM – 9 AM) - Onsite

Overview

A Sybase and PostgreSQL Database Administrator (DBA) is responsible for managing, maintaining, and optimizing databases built on Sybase and PostgreSQL platforms. This role involves ensuring database performance, availability, security, and scalability while supporting development and production environments.

Key Responsibilities

• Database Administration:

• Install, configure, and maintain Sybase and PostgreSQL database systems.

• Perform upgrades and migrations between database versions.

• Manage database objects such as tables, indexes, views, and stored procedures.

• Performance Optimization:

• Monitor and analyze database performance metrics.

• Optimize queries, indexes, and database configurations for better performance.

• Resolve performance bottlenecks and implement tuning strategies.

• Backup and Recovery:

• Develop and implement backup and recovery strategies.

• Perform regular database backups and ensure data integrity.

• Test and execute disaster recovery plans.

• Security Management:

• Implement database security policies and procedures.

• Manage user roles, permissions, and authentication mechanisms.

• Ensure compliance with data protection regulations.

• Documentation and Reporting:

• Maintain comprehensive documentation of database configurations, processes, and procedures.

• Generate reports on database usage, performance, and capacity planning.

Required Skills

• Proficiency in Sybase ASE/IQ and PostgreSQL database platforms.

• Experience with database performance tuning and optimization.

• Familiarity with backup and recovery tools and techniques.

• Understanding of database security best practices.

• Ability to work with monitoring tools (e.g., pgAdmin, Sybase Control Center).

• Knowledge of replication, clustering, and high availability solutions.

Preferred Qualifications

• Bachelor’s degree in computer science, Information Technology, or related field.

• Certifications in Sybase and PostgreSQL (e.g., PostgreSQL Certified Professional).

• Strong analytical and problem-solving skills.

Work Environment

• 5 Days Onsite 24x7 Rotational shifts also on weekend