What are the responsibilities and job description for the Database (DBA) Engineer - PostgreSQL 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 PostgresSQL/AWS Aurora Database Engineer to provide solutions and support for our customers on-premise databases, internal databases and our AWS cloud environment.
Essential Duties and Responsibilities:
- Provide installation, backup, restoring, tuning, technical support repair, and restoring corrupt databases, as needed.
- 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.
- 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, database objects including stored procedures, functions, triggers, and views; as well as deployment pipelines.
- Perform database monitoring and performance tuning.
- Detect and remediate security vulnerabilities.
- Create documentation and provide guidance to other areas of the business.
- Work with other internal teams to ensure critical data projects are completed.
- Take ownership of the SME (subject-matter expert) role on various database technologies and platforms.
- 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.
- Other duties as assigned.
Desired Experience and Skills:
- 5-7 years of experience working in database related position with SQL and coding.
- Experience with PostgreSQL and/or AWS Aurora required.
- Knowledge of PostgresSQL functions
- AWS Certification is a huge plus.
- Experience with Oracle 12c or greater a plus.
- Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
- Experience with migrating on-prem databases to AWS Aurora.
- Comprehensive experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data loading.
- Proficient in platform specific SQL and procedural languages for platforms noted in Essential Duties and Responsibilities.
- Experience in query optimization & performance tuning using industry leading tools.
- Experience with Linux OS.
- Experience with High Availability and Disaster Recovery tools and methodologies.
- 5 years’ experience with shell scripting (bash/python/PowerShell/etc.).
- 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 | PostgreSQL | Database | AWS Cloud | Aurora | RDS | Big Data | Oracle | Spark | Databricks | Shell Scripting | Bash | Linux | Python | Cassandra | MongoDB | Terraform | ETL | Data Modeling
