What are the responsibilities and job description for the Database (DBA) Engineer - Progress position at NISC?
For more than 50 years, NISC has worked to develop technology solutions for our customers, who we call our “Members”. Those Members are comprised primarily of utility and telecommunications companies across the country and abroad, and we strive to provide services and technology to help them operate efficiently and better serve their end users.
We are seeking an experienced Progress Database Engineer to provide solutions and support for our customers and internal databases.
Essential Duties and Responsibilities:
- Provide installation, backup, restoring, tuning, technical support repair, and restoring corrupt databases, as needed.
- Perform maintenance routines such as rebuilding/repairing indexes, rebuilding stats, dump/loads, and database scans.
- Work with either external or internal personnel to troubleshoot database issues.
- Develop SQL and tune application SQL as required.
- Design/develop/maintain internal systems required for NISC operations including Software Distribution and the patching process.
- Work closely with the Quality Engineering department to configure test environments.
- Develop application tools for database support, build tools, application groups, software delivery, etc.
- Design, develop and maintain database schemas and database objects including stored procedures, triggers, and views; as well as deployment pipelines.
- Perform database monitoring and performance tuning.
- Create documentation and provide guidance to other areas of the business.
- Work with other internal teams to ensure critical data projects are completed.
- Communicate, both written and verbally, with management, key users, and external vendors.
- Build and maintain key relationships with other teams and internal departments. Examples: InfoSec, Tech Support, and other external partners.
- Troubleshoot issues to find root cause and participate in corrective/preventive action measures to remediate issues.
- Create and maintain a culture of engagement and one that is conducive of NISC’s Statement of Shared Values.
- Commitment to NISC’s Statement of Shared Values.
Desired Experience and Skills:
- 3-5 years of experience working in database related position with SQL and coding.
- Experience in query optimization & performance tuning using OpenEdge tools.
- Experience with Progress OE11 or greater.
- Experience with Linux OS.
- 3 years’ experience with shell scripting (bash/python/PowerShell/etc.).
- Comprehensive experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data loading would be a plus.
- Strong verbal and written communication skills.
- Ability to demonstrate composure and think analytically in high pressure situations.
Desired Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or similar discipline, preferred.
- Certification in Database Administration, along with relevant experience in lieu of 4-year degree.
Minimum Physical Requirements:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the essential functions of this position, employees must be able to see and communicate. Employees are regularly required to maintain a stationary position, move, and operate computer keyboards or office equipment.
Disclaimer:
Management may modify this job description by assigning or reassigning duties and responsibilities at any time.
Key Words:
SQL | MySQL | Database | AWS Cloud | Aurora | RDS | Big Data | Progress | Oracle | Spark | Databricks | Shell Scripting | Bash | Linux | Python | Cassandra | MongoDB | Terraform
