Sybase & SQL Database Engineer
5 days ago
Responsibilities:
Provide Sybase database support services including configuring and responding to system and performance alerts 24x7, routine main.....
Responsibilities:
- Provide Sybase database support services including configuring and responding to system and performance alerts 24x7, routine maintenance such as patching, and actioning database related service requests across production and non-production environments.
- Sybase Data server and Replication server v16.x running on RHEL 7/8/9
- Microsoft SQL Server 2008/2012/2014/2016 and 2019 Instances and Databases
- Microsoft SQL Server Components such as Database Engine (SSDS), Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS)
- Microsoft SQL Servers using Physical and Virtual Machines hosted on Microsoft Windows Servers (2008/2012/2016)
- Microsoft SQL Server technologies such as SQL Alwayson (AG), Database Mirroring, Transaction Log Shipping, SQL Server Replication and Windows Standalone/Clustering using Storage-level replication.
- Install, configure, upgrades, applying patches to Microsoft SQL Server Instances BOFA cloud services
- Troubleshooting, Database performance and tuning, Availability monitoring using Quest Foglight
- Implement Microsoft SQL Server Database features such as Compression, Encryption, Linked Servers, and Partitioning
Requirements:
- Bachelor's degree in Computer Science, Engineering, or related field
- 12 to 15 years of total work experienced as Database Administrator / Engineer.
- At least 3 to 5 years’ recent working experience with Sybase ASE 16 SP4, Replication server 16 SP3 and SAP IQ 16.1 on a mix of Microsoft SQL Servers and Redhat Linux servers.
- Experience on SYBASE Data Server and Replication administration is mandatory
- In-depth knowledge of Microsoft SQL Server Instances, Database administration and SQL Server components such as Database engine (SSDS), Integration Services(SSIS), Reporting Services(SSRS) and Analysis Services(SSAS) running on Windows Standalone and Cluster servers
- Strong understanding and/or working experience of Microsoft SQL Server installation, upgrade, database setup and implementation of SQL Server technologies such as SQL AlwaysOn, Database Mirroring, Log Shipping, SQL Replication and Windows Standalone\Clustering using Storage-level replication for High availability and Disaster recovery.
- Experience in SQL Server Instance upgrade from SQL Server lower version to latest version and Database migration from one SQL Server to another
- Strong knowledge in utilizing SQL Server monitoring and troubleshooting / performance tools such SQLCMD, SQL profiler, Database Import/Export, Database upgrade tool and SQL Server Management Studio
- Experience in addressing SQL database alerts/issues, capacity constraints and performance related items.
- Demonstrated ability in problem solving, identify tuning opportunities, implement improvement, and advise Production support/developer teams on root cause/analysis, SQL tuning and permanent solution.
Mandatory Skills:
- Sybase ASE, REP & HADR: 12.5.x, 15.x, 16.x
- Sybase IQ: 15 or above
- Microsoft SQL Server 2008/2012/2014/2016 and 2019
Official account of Jobstore.