Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the Kansas City, St. Louis, Denver, and Dallas Areas.
We are currently looking for a PostgreSQL DBA to join our team.
Primary Duties and Responsibilities:
Leads design of databases for modules of larger projects, monitoring progress to ensure timely completion of deliverables
Helps determine appropriate architecture, and other technical solutions, and makes relevant recommendations to the project manager or clients.
Works closely with project managers and other members of the development team to develop detailed specification documents with clear project deliverables and timelines
Work with clients, project managers, and designers in migrations of applications and databases to new environments
Communicates to the project manager with efficiency and accuracy any progress and/or delays
Coordinates with Information Security Office on assessing the risk of the database environments and appropriate controls to protect the confidentiality, integrity, and availability of the information
Tests applications to ensure performance and capacity plans meet expectations, including performing index tuning, query writing, and optimization
Designs and develops application database structure, tables, entity relationships, and security privileges
Ensures designs make efficient use of network and database resources
Coordinates work with other team members for application development, administration, information security, and network administration to ensure that architecture, functionality, and design are consistent with all information technology strategies
Researches and evaluates new technology, products, specialized hardware and tools to optimize development and functionality of websites and applications
Applies experience with disaster recovery and data replication techniques to protect departmental information and systems in the event of disaster or data loss
Performs other duties as assigned
Certification or degree in computer programming or database administration from a technical school or college plus a minimum of 5 years of relevant experience required; additional programming or database administration experience may be substituted on a year-for-year basis for required education.
Planning and Organizing: Ability to organize and follow complex and/or detailed technical procedures and communicate those concepts to technical and business resources; ability to work independently and perform job with minimal supervision.
Project Management: Ability to manage multiple complex projects.
Technical Knowledge: Ability to work on most phases of database systems administration with a focus on (but not limited to) PostgreSQL environment; knowledge of additional database environments (e.g., Oracle, MySQL, MS SQL) a plus; working knowledge of data warehousing, extract transform and load (ETL), migration of data from legacy database platforms, backup and restore procedures
Technical Solution Development: Ability to devise or modify databases to solve moderately complex problems considering computer equipment capacity and limitations; knowledge of system development and/or maintenance technologies to support the infrastructure that assigned databases resides upon and maintains that infrastructure.
Technical Support: Knowledge of technical features to assist in problem determination and resolution.
Consultancy Skills: Ability to consult with clients and higher-level technicians and analysts to resolve technical problems and ensure client satisfaction; ability to interact with client to discuss alternative technical solutions.
Adaptive Solutions Group offers a competitive compensation and benefits package that includes medical, dental, STD/LTD, life insurance coverage, 401k, paid vacation and holidays.
Adaptive Solutions Group is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, and veteran or disability status.