Database Administrator II
Company: Professional Management Enterprises
Location: Indianapolis
Posted on: April 18, 2024
|
|
Job Description:
Provides ongoing support of business, including ongoing data
analysis, data quality testing, enhancement of metadata, etc.
Reviews SQL code and provides turning suggestions. Provides DBMS
technical configuration and troubleshooting. Provides user
management and DBMS security support. 24x7 production and
non-production DBA on-call support. Requires BA/BS in Computer
Science or Information Systems or related field; 3 or more years of
information systems experience; or any combination of education and
experience, which would provide an equivalent background. Requires
general business knowledge, general technical knowledge and
knowledge of database administration techniques. Excellent written,
oral and interpersonal communication skills required. Experience in
utilizing DBMS system management tools and the ability to implement
new DBMS features and functionality.
***Must be able to obtain a U.S. Federal Position of Trust
clearance designation. ***
Responsibilities
* Responsible for the maintenance of production, test and
development databases.
* Brings solid understanding of database administration.
* Supports development team from a database design and development
perspective.
* Responsible for database administration or engineering
activities, ensure optimal performance on PostgreSQL
environments.?
* Responsible for the installation, maintenance, configuration, and
integrity of PostgreSQL architecture.?
* Performance tuning of the queries.
* Provide support to the application developers, including, but not
limited to data refresh, SQL and PL/pgSQL performance tuning and
best practice recommendations.
* Conduct code reviews with application developers.
* Ensure the long-term requirements of systems operations and
administration are included in the overall database systems
planning of the organization.?
* Perform many related database functions across one or more teams,
including designing, implementing, and maintaining new databases,
backup/recovery and configuration management.
Required Qualifications
* Bachelor's degree
* 3+ years of experience as a DBA / developer for complex and
high-volume data warehouse projects.?
* AWS certification
* Strong PL/PGSQL or PL/SQL experience is a plus.?
* Experience in PostgresSQL, AWS RDS Aurora PostgreSQL.?
* Hands-on experience with Postgres database administration,
performance tuning and production support in a high volume,
customer-facing apps/environment.?
* Data modeling experience
* Experience working in Agile/ Scrum programs with
multi-disciplinary development teams
* Excellent written, verbal, and interpersonal communication
skills
* Manages time extremely well, can quickly sense when issues need
to be addressed
* Strong attention to detail and focus on task completion.
Preferred Qualifications
* Experience with health IT systems with Electronic Data Interface
(EDI) processing
* Experience with 270/271 transactions and/or other X12 data
formats
* Experience with healthcare data, specifically
Medicare/Medicaid
* 5+ years of experience as a DBA / developer for complex and
high-volume data warehouse projects.
PME is an equal opportunity employer. We prohibit discrimination
and harassment against any applicant or employee based on any
legally recognized basis, including, but not limited to: veteran
status, uniformed servicemember status, race, color, religion, sex,
sexual orientation, gender identity, age (40 and over), pregnancy,
national origin or ancestry, citizenship status, physical or mental
disability, genetic information (including testing and
characteristics) or any other category protected by federal, state
or local law.
Keywords: Professional Management Enterprises, Lawrence , Database Administrator II, IT / Software / Systems , Indianapolis, Indiana
Click
here to apply!
|