Oracle/SQL Server DBA - Allentown, PA

Company: DEW Softech, Inc
Your Application: You have not applied yet
Location: Allentown, PA, USA

Position: SQL/Oracle DBA

Location: Remote 100%

Duration: 12+ months

Rate: Open

Interview: Video


100% remote


Position Description:

This team is responsible for the technical support of Client infrastructure along with providing follow the sun technical support to the Americas and Asia region during their off hours.


This position provides database administration and support for Microsoft SQL Server and Oracle database servers distributed across the globe which host critical applications such as SAP. The incumbent would be responsible for administering and maintaining existing databases and would provide DBA skills for projects requiring pre-engineered database solutions.


The ideal candidate will have hands on experience with management and troubleshooting on the following systems.


Core Skills for Microsoft SQL Server and Oracle


Installation Design, creation, and maintenance of databases and associated database objects Monitoring performance and availability Backup and restore Security design Quarterly Oracle security patching Periodic maintenance processes Query troubleshooting and tuning Connectivity troubleshooting Working knowledge of T-SQL and PL/SQL



A good knowledge in several of the following areas will be an advantage


SAP HANA Experience in building and supporting cloud-based databases and services (AWS, Azure) Knowledge of open-source database systems (PostgreSQL, MySQL, NoSQL) Experience with Windows Server OS UC4 (Automic) operation and programming PowerShell, Windows command line programming



Position Responsibilities:


Participation in scheduled Disaster Recovery exercises as needed (MS SQL Server based) Meet with and work with database administrators in the Americas Engineering organization as needed to support Client business needs Work with application & database developers to resolve issues and develop and implement solutions Assist and advise SQL Developers with code optimization as needed Work to resolve and alleviate failures, problems, or concerns in a timely manner Provide root cause analysis for outages when appropriate Perform SQL code releases to our database environments when needed Participate in Global DT projects
to create/maintain database infrastructures as required by business needs. Provide 7x24 level 2-3 global support for AP computing platforms, infrastructure hardware/software, services, processes, and offerings that are supported by Information Technology (IT) Engage support providers (E.g.: MS, VMWare, etc.) as appropriate to resolve issues and ensure continuous availability to AP business processes, connectivity, communications, and services Collaborate with Infrastructure Engineering, in design, integration, testing and landing of new and enhanced information systems, services and offerings Understand, adhere to, and execute adopted ITIL practices for Change, Incident, Problem and Release Management Provide technical subject matter expertise to project teams and support teams as needed Author, review, and maintain documentation required for knowledge transfer and training to successfully land new solutions into the support organization Develop and implement technical solutions that meet operational improvement needs.




Bachelor's degree in Information Systems or Computer Science, specialized training, certification, or equivalent work experience. Approximately 5+ years of experience within one or more areas within Information Technology (IT) or comparable organization, preferably at least 3 years spent working directly with databases Strong analytical along with logical approach to troubleshooting and problem-solving skills are essential across multiple services and technologies. Candidate must possess strong verbal and written communications skills to effectively communicate technology changes to clients inside and outside of IT General understanding of Project Management methodology General understanding of Information Technology (IT) infrastructure and processes (ITIL) Ability to assess and prioritize competing issues and opportunities Ability to anticipate potential problems and develop solutions needed to resolve them Ability to effectively work independently and collaboratively across global, cross organizational team environments and participate in virtual projects, work requests or activities Able to prioritize and meet milestones when working on multiple projects simultaneously Strong interpersonal and teamwork skills Strong ability to work with strategic vendors, outside service/support providers and other third-party suppliers

Work Day: Full Time
Employment type: Permanent Job
Salary: Negotiable

Minimal experience: No experience

Jobs you may be interested in

    Tips You May Be Interested In