Sql server dba Jobs in Augusta, GA

Ali Al Zayer Co. was established in the year 1992 with a focus on the workforce , Project Management sector. It quickly grew into a reliable and trusted service provider in the Oil & Gas , Construction Sector within The Kingdom.

In 2010, Ali Al Zayer Co had partnered with some of the Industry leaders , Yokogawa, Zamil, TQ , Rawabi, L&T, CB&I to expand its presence into the trading and product portfolio sectors.

In 2015, Ali Al Zayer Co, partnered with one of the worlds largest leading education provider to manage it’s facilities in The Kingdom. This later expanded to include the provision of the workforce to deliver quality education to The Saudi Youth.

Ali Al Zayer Co. has since made strides by establishing itself as one of the most reliable and trusted provider of qualified Educational Experts and Specialist Workforce.

Ali Al Zayer Co. has aligned itself with the Vision 2030 of The Kingdom, and it is reflected on the quality of service being provided.

The Role

You will be responsible for :

• Installation of Oracle 11g / 12c / 19c on Windows, Solaris and Linux OS
• Installation of PeopleSoft Application and PeopleTools on Linux / windows environments.
• Database Administration, Tuning and support for the application systems as per the database requirements.
• Maintenance of Prod and Non-Prod environments in Peoplesoft
• Create and maintain Users, Profiles, Roles and Privileges and Prod and Non- Prod.
• Setup PeopleSoft Web server, Application server domains, Process Scheduler, SQR, Crystal Reports, COBOL compiler installation / configuration.
• Installed, configured Web server, Application server, Process Scheduler, Report Servers.
• Upgrade and patches on java and Oracle Weblogic for Webserver.
• Upgrade and patching of Tuxedo for application server.
• Configuration and renewal of SSL and Forgot Password feature.
• Download and apply PeopleSoft bundles and patches using PUM image.
• Apply required People Tools patches.
• Apply critical database patches when release by Oracle.
• Perform people Tools Upgrade to latest PT version (8.60) and point patches whenever required by team.
• Migration of PeopleSoft application and database from existing server to another server across the different OS platform.
• Help OS support team (SIS Team) for PeopleSoft / Oracle related kernel parameter tuning.
• Setup new PeopleSoft environment whenever required.
• Create backup & Recovery procedures, copying databases and setup new PeopleSoft environments.
• Taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
• Enabled / Disable the Database in Archive Log Mode.
• Taking Backup & Recovery using Hot & Cold Backups for oracle Database (Prod and Non-prod).
• Listener and client connectivity configuration and troubleshooting.
• Troubleshooting in case of any problem related to OS / RDBMS / Application.
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements.
• Checking Alert Logs, Archive Logs, Trace files and backup verifications
• Cloning the database from existing Database.
• People Books installation.
• Kibana Analytics and Global Search. SES
• Single Sign on for PeopleSoft Applications with other Applications.
• Implementation of LDAP between PeopleSoft and Microsoft AD.
• Troubleshooting PeopleSoft application performance as and when required

Ideal Profile

What's on Offer?