Project Role : Operations Engineer
Project Role Description : Support the operations and/or manage delivery for production systems and services based on operational requirements and service agreement.
Must have skills : Sybase Database
Good to have skills : NA
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education
Summary:
Act as the ongoing interface between the client and the system or application. Responsible for end-to-end database and infrastructure administration across MSSQL, Sybase, and AWS environments. Ensures availability, performance, security, and reliability through proactive monitoring, advanced troubleshooting, and continuous improvement initiatives.
Must Have Skills:
MSSQL Server, Sybase ASE, AWS (EC2, RDS, VPC), Database Administration, Infrastructure Operations
Job Requirements:
Key Responsibilities:
Administer MSSQL and Sybase databases including installation, configuration, patching, and upgrades
Manage MSSQL AlwaysOn Availability Groups, clustering, and failover mechanisms
Administer Sybase replication servers, backup servers, and performance tuning
Manage AWS infrastructure including EC2, RDS, storage (EBS), networking (VPC), IAM roles, and security groups
Perform proactive monitoring of database performance, query execution, and system health
Troubleshoot complex issues such as deadlocks, blocking, query performance, and latency
Perform root cause analysis (RCA) and implement permanent fixes for recurring database issues
Manage database backups, restores, log shipping, and disaster recovery strategies
Implement database security, user access control, encryption, and compliance policies
Optimize queries, indexing strategies, and database performance tuning
Execute patching, upgrades, and vulnerability remediation activities
Design and maintain high availability and disaster recovery solutions across on-prem and AWS
Automate database maintenance tasks using scripts and scheduling tools
Collaborate with application teams for DB performance optimization and deployments
Maintain documentation, SOPs, and knowledge base
Enterprise Tools & Platforms:
Monitoring: Splunk, Database Performance Analyzer
Logging: Splunk, ELK Stack
DB Tools: SQL Server Management Studio (SSMS), SQL Profiler, Sybase Central
Cloud Tools: AWS CloudWatch, AWS RDS Performance Insights, Trusted Advisor
ITSM: ServiceNow
Automation: PowerShell, T-SQL scripts, Shell scripting
Backup Tools: Veeam, Commvault, Native DB backup utilities
Security Tools: Qualys, Nessus
SLA / KPI Ownership:
Ensure adherence to SLA/KPI commitments
Track MTTR (Mean Time to Resolve) and MTTA (Mean Time to Acknowledge)
Monitor MTBF and database availability
Publish weekly/monthly service performance reports
Drive service improvements and optimization initiatives
Client Facing Responsibilities:
Lead and participate in war room calls during major database incidents
Manage escalation matrix and stakeholder communication
Provide periodic updates to business and technical stakeholders
Participate in governance, CAB, and service review meetings
Technical Experience:
5+ years of experience in database and infrastructure administration
Strong troubleshooting and RCA expertise
Experience with HA/DR architectures (AlwaysOn, replication)
Hands-on AWS cloud and automation experience
Professional Attributes:
Strong communication and stakeholder management
Ability to handle critical incidents and escalations
Flexible to work in 24/7 environment
Strong analytical and problem-solving mindset
Educational Qualification:
Bachelor s degree
15 years full time education
