Sybase Operations DBA - Mechanicsburg, Pennsylvania at Mechanicsburg, Pennsylvania, USA |
Email: [email protected] |
From: pankaj, stellentit [email protected] Reply to: [email protected] Sybase Operations DBA Mechanicsburg, Pennsylvania Phone and Skype Long Term Candidates will be asked to workONSITE for 6 weeksthen will be able to work2 days per week remotely Job Description: This is an advanced technical position responsible for understanding the organization's database installation stores, maximizing end-user productivity. Responsibilities include planning, installation, monitoring, and maintenance of database server software as well as working with other technical teams to assist in the creation and maintenance of their databases. The individual in the position will ensure best database administration practices for all Microsoft SQL Server and SAP (formerly Sybase) Adaptive Server Enterprise installations and assist staff with database creation, customization, and scripting. TYPICAL DUTIES: Manages and performs detailed functional development and testing of database server administration maintenance scripts to include backups, index defragmentation, database consistency checks, and log checks. Monitors and addresses database server performance issues to include running SQL profiler, identifying long-running SQL, advising development teams to improve performance, optimizing performance using techniques including indexing and schema normalization/denormalization, capacity planning, and server resource usage. Develops and maintains data integrations using SSIS. Administers security and maintains login Writes and maintains appropriate documentation of policies and procedures for database administration functions. Handles on-call issues by responding to automated monitoring notifications and calls from other staff as required. Problem analysis and resolution may in some cases be accomplished through remote access to AOPC systems but may at other times require physical presence at AOPC facilities. |
[email protected] View all |
Tue Oct 18 00:30:00 UTC 2022 |