Sorry! This job is no longer available. Please explore similar jobs listed on the left.
Professional Management Enterprises is Hiring a Database Administrator II Near Indianapolis, IN
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.
It is the policy of the Company to provide equal employment opportunities to all qualified individuals and to administer all aspects and conditions of employment without regard to the following:
• Race and associated traits, including hairstyle; Color, Age, Sex, Sexual orientation, Gender, Gender identity and gender expression; Religion, including dress and grooming practices; National origin, including language use restrictions; Pregnancy, childbirth, or breastfeeding; Marital or familial status; Genetic information, including family medical history; Physical or mental disability; Citizenship and/or immigration status
• Medical conditions, including cancer, AIDS/HIV, and occupational pneumoconiosis without respiratory impairment
• Denial of family or medical care leave
• Use of a guide or support animal
• Military or veteran status
• Political activities or affiliations
• Exercise of civil rights
• Domestic violence, assault, or stalking victim status
• GED certificate
• Arrest, expunged, or sealed records
• Application for or enrollment in Medi-Cal
• Status as a smoker or non-smoker
• Credit report or credit information
• Child or spousal support withholding
• Wage garnishment for consumer debt
• Relationship with someone with a disability
• Lawful conduct occurring during nonworking hours not on Company premises
• Any other protected class, in accordance with applicable federal, state, and local laws
Discriminatory, harassing, or retaliatory behavior is prohibited from coworkers, supervisors, managers, owners, and third parties, including clientele. The Company takes allegations of discrimination, harassment and retaliation very seriously and will promptly conduct an investigation when warranted. Equal employment opportunity includes, but is not limited to, employment, training, promotion, demotion, transfer, leaves of absence and termination.
Job Summary