3292 - DBA

Procession Systems
Bethesda, Maryland
Full-time

GENERAL DUTIES :

  • Provide technical expertise and support in the use of PostgreSQL DBMS
  • Create and maintain database objects such as tables, views, index, constraints 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
  • Create views to drive front-end data analytics and reporting
  • Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools
  • Enhance and maintain logical and physical database designs from application requirements
  • Design and implement automation using SQL scripts and database functions
  • Respond to user reported errors in a timely manner
  • Monitor systems performance and identifying problems that may arise
  • Liaison with developers and IT project managers
  • Recommend changes and enhancements for database performance and protection
  • Maintaining an awareness of trends and developments in database development and administration
  • Leverage experience to provide support in the areas of data mapping, data extraction, transformation, and loading (ETL)

REQUIRED QUALIFICATIONS :

  • At least 5 years of experience in administering on-prem / cloud based multiuser environment with expertise in planning, designing, building, and implementing complex database systems
  • Experience with AWS RDS or Aurora for PostgreSQL
  • Familiar with open-source DBMS tools such as pgAdmin, pgModeler, or DBeaver
  • Experience with data modeling and Entity-Relationship Diagrams (ERDs)
  • Experience with Structured Query Language (SQL)
  • Possess analytic problem-solving skills
  • Knowledge of computer software applications, including database technologies and programming languages
  • Excellent verbal and written communication skills

DESIRED QUALIFICATIONS :

  • Bachelor’s degree in computer science, software engineering, or related field of study
  • Experience implementing and deploying databases in Amazon Web Services (AWS)
  • 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 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 BILLET TBD exhaustive proactive testing and ongoing real-time monitoring
  • Experienced in SQL 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
  • 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 PostgreSQL DB
  • Experience with AGILE / DEVOPS a plus

CLEARANCE :

  • Full Scope Polygraph minimum
  • 30+ days ago
Related jobs
Procession Systems
Bethesda, Maryland

Provide technical expertise and support in the use of PostgreSQL DBMS.Create and maintain database objects such as tables, views, index, constraints for data platform and custom applications.Develop, implement, and maintain database backup and recovery procedures for the processing environments, and...

Promoted
WOOD Consulting Services, Inc
Laurel, Maryland

Provides specific input to the software components of system design to include hardware/software trade-offs, software reuse, use of Commercial Off-the-shelf (COTS)/Government Off-the-shelf (GOTS) in place of new development, and requirements analysis and synthesis from system level to individual sof...

Promoted
DMI (Digital Management, Inc.)
Bethesda, Maryland

Architect, implement and administer globally distributed Oracle instances. Oracle Certified Professional. ...

Promoted
VirtualVocations
Rockville, Maryland

Key Responsibilities:Maintain data pipelines for content and user embeddingsUtilize LLMs for data summarization, categorization, and labelingCollaborate with Data Science to develop and optimize machine learning modelsRequired Qualifications:1 to 3 years of experience with web APIsProficiency in Pyt...

Promoted
Towne Park
Oxon Hill, Maryland

The Cashier is responsible for accurately collecting and reconciling revenue while providing exceptional hospitality services to all guests in an attentive, friendly and efficient manner. Completes all tasks in a timely manner as instructed by the Lead Cashier/Account Manager. ...

Promoted
WLR Automotive Group
Gaithersburg, Maryland

The Cashier creates the initial atmosphere for each customer by his/her greeting and is responsible for helping each customer in a friendly, enthusiastic, and professional manner. The Cashier is also responsible for processing payment for each customer. ...

Promoted
Home Depot
Rockville, Maryland

A Head Cashier will position Cashiers and support them by expediting price checks, approving Point of Sale transactions and markdowns for mainline registers, Self-Checkout, Returns, Pro Desk, Special Services, and Tool Rental. They provide first level escalation for customer issues and assist in the...

Promoted
BCC-NIH
Bethesda, Maryland

STEM field (Engineering, Computer Science, Mathematics, Physics). Experience running operations in a large and complex environment, preferably in data operations. Work experience with production-level bioinformatics databases and pipelines. Familiarity with technical environments, complex databases,...

Promoted
Accenture
Suitland-Silver Hill, Maryland

Accenture Federal Services is seeking a Data Engineer to assist with the data platform blueprint and design, encompassing the relevant data platform components. Create data pipelines, ensure data quality, and implement ETL (extract, transform and load) processes to migrate and deploy data across sys...

Promoted
AlienVault
Laurel, Maryland

The job duties of the MS SQL Server Database Administrator are as follows:Work in an environment supporting multiple applications that rely upon Microsoft SQLServer as their backend database. Ready to join our team? Apply Today 'Joining our team comes with its perks Now offering a $20,000 Sign-on-Bo...