Outcomes. Delivered.
GCOM Software is changing the way governments work. And we’re supporting our clients in a new way. We’re reliable, capable and agile. Our fast paced and energetic culture allows our employees to make an impact.
We are proud to do work that matters – and to be viewed as a national player in the government arenas of regulatory and inspection automation, customer engagement and criminal justice systems and the Women Infant and Children (WIC) programs. We also specialize in product development, custom off the shelf (COTS) Implementations, and system integration services, including full application development lifecycle.
At GCOM, we are known as being a great place to work and a place to build your career! You will work with awesome technical teams to design and implement solutions for clients in a multiplatform environment. You will be encouraged to be creative and given the opportunity to leverage a wide variety of technical tools. Your energy, analytical, technical and business skills will drive real impact in your community.
Are you looking to Collaborate, Innovate and Thrive? Come join our growing team doing great work to make lives easier for the constituents of state and local governments.
GCOM is looking for candidates, to fill a role of Application DBA Senior to join our team in Linthicum, MD.
Key Responsibilities:
- Provide technical expertise and support in the use of DBMS.
- Evaluate and recommend available DBMS products to support validated user requirements.
- Define file organization, indexing methods, and security procedures for specific user applications.
- Create and maintain database objects such as tables, views, index, constraints, etc. for data platform and custom applications.
- Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
- Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
- Design and develop logical and physical database designs from application requirements.
- Design and implement automation using scripts and database functions.
- Design and implement replication and backups for mission critical/tier-1 applications.
- Design and implement automation using scripts, must be proficient in scripting.
Qualifications:
- At least six (6) years of experience in administering on-prem/cloud based multiuser environment with expertise in planning, designing, building, and implementing complex database systems.
- In depth knowledge of the EDB PostgreSQL DB architecture.
- AWS cloud base Postgres database administration experience.
- Driven end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
- Implemented automated methods and industry best practices for consistent installation and configuration of EDB PostgreSQL for production, pre-production and non-production environments.
- Administrated PostgreSQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment.
- Experienced with optimizing database performance through exhaustive pro-active testing and ongoing real-time monitoring.
- Experienced in scripting and database functions.
- Experience in testing database security and enterprise policy guidelines according to established best practices.
- Monitored and maintained the backups for database recoverability for all production databases.
- Must have experience working in the database domain with at least four (4) years of experience managing all operations of RDBMS databases such as Oracle/SQL Server/DB2 with a minimum of two (2) years of EDB PostgreSQL DB.
- Experience with AGILE / DEVOPS a plus.
- Functional experience in Federal and/or State health and human services (HHS) programs is preferred (i.e., Child Welfare (CCWIS), Child Support, Adult Protective Services, Juvenile Services, Supplemental Nutrition Assistance Program (SNAP), Temporary Assistance for Needy Families (TANF), Women, Infants & Children (WIC), Electronic Benefits Transfer (EBT), Medicaid, Children Health Insurance Program (CHIP), Care Management, EHR, Child Care).
- Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline.
Any interested candidates will need to submit their resumes by before 5 PM EST on Friday, 17th September 2021.
If you think you are a good fit for us, we encourage you to apply. Check out our new career website for all open positions!
GCOM provides equal employment opportunities to all employees and applicants for employment without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status or domestic violence victim status, religion, age, disability, genetic information, service in the military, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Equal employment opportunity applies to all terms and conditions of employment, including recruitment and hiring, job assignment/placement, promotion, upgrading, demotion, termination, layoff, recall, transfer, leave of absence, rates of pay or other compensation, internship, and training.