Database Admin Architect

Global CI (Global Commerce & Information, Inc.); Milford Mill (MD); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical benefits

401k plan

Paid time off

Referral bonus

Community service hours

Tuition reimbursement

Employee discounts

Job summary

Global Commerce & Information, Inc. is seeking a senior Database Admin/Architect to lead PostgreSQL environments in our Maryland on-site team.

You will optimize performance, manage backups, and design scalable data solutions across AWS services, ensuring compliance and high availability. The ideal candidate has 10+ years in database administration, strong SQL skills, and a track record of collaboration with data scientists and developers.

Qualifications

• 10+ years as a Database Admin/Architect
• Experience with AWS RDS PostgreSQL or other cloud PostgreSQL platforms
• Strong expertise in data modelling, normalization, and schema design
• Proven ability to design backup, disaster recovery, and high-availability solutions

Responsibilities

• Manage, maintain, secure, monitor and optimize PostgreSQL databases for high availability and performance
• Database monitoring and health checks
• Backup and recovery management
• Database installation, updates and configuration
• Write complex SQL queries for data analysis and reporting
• Design scalable, secure database solutions and integrate with AWS services (Lambda, S3, EC2, Glue)
• Implement security and compliance practices (IAM, encryption, VPC)
• Provide guidance to junior/mid-level developers

Skills

PostgreSQL

SQL

Database management

Data Modelling

Data Analysis

Splunk

Server patching

Education

Master's degree

Bachelor's degree

13+ years in lieu of a degree

Tools

AWS RDS PostgreSQL

Linux

Job description

Your Success is Our Success. Global CI is an award-winning 30-year IT Services company founded on the principles of providing high-quality, value-added technology consulting services. Our vision is to create a better future by improving the lives of the people we serve through emerging technologies. Join us and together we will advance the future of technology services.

Global CI offers competitive compensation and non-salary benefits to all eligible employees.

Key Required Skills

Experience with PostgreSQL, SQL, Database management, Data Modelling, Data Analysis, Splunk and Server Patching

Position Description

• Managing, maintaining, securing, monitoring and optimizing PostgreSQL databases to ensure high availability and performance.
• Database monitoring and health check
• Backup and recovery management
• Database installation, updates and configuration
• Write complex SQL queries for data analysis, transformation, and reporting.
• Optimize queries, manage caching, clustering, and leveraging auto-scaling to handle workloads.
• Architect scalable, high-performance, and secure database solutions.
• Integrate databases with other AWS services such as Lambda, S3, EC2, and Glue.
• Utilize AWS security best practices (IAM, encryption, VPC, security groups) and compliance requirements for data storage.
• Design backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).
• Ensure compliance with SSA security, privacy, and data management policies.
• Provide guidance/support to other junior/mid-level developers.
• All other duties as assigned or directed.

Skills Requirements

10+ years as a Database Admin/Architect

Required Skills

Selected candidate must be able to obtain and maintain a public trust clearance

Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week

Master's and 5+ years of experience, Bachelor's and 7+ years of experience or 13+ years in lieu of a degree

• Skilled in PostgreSQL database management, data modeling, normalization, and schema design.
• Advanced skills in writing complex SQL queries for data analysis, transformation, and reporting.
• Skilled in designing backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).
• Strong experience with database architecture, configuration, installation, backup and recovery.
• Experience with AWS RDS PostgreSQL or other cloud PostgreSQL platform
• Strong experience with Logical and Physical data modelling
• Experience with Server patching
• Experience with Splunk
• AWS Experience:
• Proven ability to architect scalable, high-performance, and secure database solutions, with proficiency in query optimization, indexing, caching, and performance tuning using AWS tools.
• Experienced in integrating databases with other AWS services such as Lambda, S3, EC2, and Glue.
• Adept at securing AWS clusters, managing IAM roles, implementing encryption, and monitoring jobs using AWS tools (CloudWatch, CloudTrail).

Desired Skills

• Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
• Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
• Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)
• Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
• Detail oriented and committed to consistently completing repetitive production-like tasks on-time and error-free.
• Prior experience working in a federal agency or public sector environment.
• Effective communication skills for working with cross-functional teams, including data scientists, analysts, and business stakeholders.
• Ability to translate technical concepts into non-technical terms for business stakeholders.
• Ability to manage multiple projects, prioritize tasks, and deliver within deadlines.

Benefits Include

• Comprehensive medical, dental, vision, life, and short & long-term disability insurance + health savings account
• Matching 401k retirement plan + IRA's and Roth IRA's
• Generous paid time off and paid holidays
• Employee recruitment/referral bonus
• Paid community service hours
• Tuition reimbursement
• Employee discounts

At Global Commerce & Information, Inc. we celebrate, support, and are committed to creating a diverse and inclusive environment. We're proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status, or any other legally protected characteristics.

Global Commerce & Information, Inc maintains a drug-free workplace.