PostgreSQL DBA in Lawrence, KS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



CA&L, an industry leader in online assessment delivery for the K-12 market, is currently recruiting a PostgreSQL DBA who will be responsible for complete database management, primarily supporting multiple application development teams to implement and support data-oriented application efforts. The DBA position also participates in the development and design of database strategies, system monitoring, capacity planning, backup and recovery, security and auditing, performance tuning/monitoring, installations, and upgrades. 

 

 

Essential Functions / Job Duties:

1.     Works with the development, IT, and PMO teams to maintain all development and test database instances

2.     Works with DevOps and Developers to build and implement automated processes for migration of schema changes and data changes through development, test and production

3.     Assists the development team as necessary with query optimization

4.     Identifies database requirements; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems; database creation and maintenance, ongoing performance optimization, and end user support.

5.     Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications

6.     Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products

7.     Assists users by conducting training; providing information; resolving problems

8.     Supports database functions by designing and coding utilities

9.     Maintains quality service by establishing and enforcing organization standards including change management

10.  Creates and updates existing documentation of processes and procedures in support of administration tasks

11.  Participates in capacity management, expansion and growth planning

12.  Works closely with systems administrators, business systems analysts and developers regarding the modeling, implementation and administration of database servers

13.  Provides recommendations concerning database related components of development efforts

14.  Responsible for maintaining discretion related to all confidential/sensitive company and customer information

15.  Stay up to date on industry advancements, best practices and standards, skillfully and effectively communicating these to the team.

16.   Perform other duties as reasonably requested by management (company wide job duty).

 

Position Qualifications:

 

Education: Bachelor’s in Computer Science or related fields or equivalent experience.

 

Experience:

  • Solid understanding of database design principals
  • At least 2 years of experience as a DBA with a minimum 1 year experience with Postgresql 8.3 - 9.5
  • Solid understanding of query execution plans
  • Good SQL scripts skill including SPs, PSQL scripting
  • Good performance tuning skills
  • Ability to proactively identify, troubleshoot and resolve live database systems issues.
  • Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
  • Experience in replication
  • Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments
  • Experience with NoSQL databases (Mongo, Cassandra, Hadoop, Redis) preferred
  • Experience with Database refactoring/migration tools a plus
  • Strong experience with the following technologies:
    • Operating Systems: Linux and Windows
    • Programming Languages: Python and Shell Scripting
    • Preferred experience with: TOAD,  SQL Developer, PgAdmin
  • Strong working knowledge of Unix/Linux systems administration and troubleshooting        
  • Strong experience with load balancing and high volume, high availability environments
  • Minimum 3 years’ experience with software development lifecycle (SDLC)
  • Minimum 1 year experience working on Agile Methodologies / Frameworks
  • Experience in planning, scope identification, estimating work effort and producing quality deliverables on time and within budget

Skills:

  • Strong analytical and problem solving skills with ability to clearly articulate solution alternatives
  • Ability to coordinate multiple projects and participate in varying levels of programming effort.
  • Team Player
  • Ability to gather business requirements and develops the conceptual design and technical design for multiple projects concurrently.
  • Ability to solve complex issues that cross team boundaries.
  • Ability to troubleshoot systems, performance and environmental concerns.
  • Ability to communicate effectively with a variety of audiences including project management, developers, and business systems analysts.

 

Please apply on the company website by following the link below:

 

http://caltesting.org/careers.html

 


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql Admin]     [PHP Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux