This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description As a Staff Database Reliability Engineer, you will own the performance, reliability, and scaling strategy for our PostgreSQL Aurora infrastructure that powers creative workflows for leading brands. As a technical leader, you'll partner closely with backend engineering and leadership to architect scalable solutions, establish best-in-class database operations practices, and build the observability framework that keeps Air running at 99.99%+ uptime. Core Responsibilities - Ensure Database Reliability & Performance - Own the health, performance, and availability of Air's PostgreSQL Aurora infrastructure. - Proactively optimize database parameters, indexes, and query patterns to maintain sub-100ms p95 response times. - Uplevel migration practices and tooling to ensure zero-downtime schema changes as the platform scales. - Establish and maintain comprehensive backup, recovery, and disaster recovery procedures with documented RTO/RPO targets. - Partner with backend engineers to implement database best practices in application code (connection pooling, query optimization, caching strategies). - Plan and Execute Long-Term Scaling Strategy - Develop multi-quarter roadmap to scale Air's database infrastructure to support 10x growth in asset volume and user activity. - Collaborate with backend engineers and product leadership to model data growth patterns and anticipate scaling inflection points. - Evaluate and implement horizontal scaling strategies (read replicas, sharding, partitioning) aligned with business needs. - Continuously assess AWS Aurora capabilities, PostgreSQL ecosystem innovations, and emerging database technologies for strategic advantage. - Design and implement database architecture that supports Air's AI-powered features and real-time creative workflows. - Build Observability and Data Health Framework - Create comprehensive monitoring, alerting, and reporting systems to maintain database reliability and inform data-driven infrastructure decisions. - Implement detailed instrumentation for database performance metrics (query latency, connection pool utilization, replication lag, disk I/O). - Build automated alerting for anomalies in query performance, connection patterns, and resource utilization. - Create executive-level dashboards showing database health trends, capacity utilization, and cost efficiency. - Develop regular database health review cadence with engineering leadership to surface insights and drive continuous improvement. Qualifications - 5+ years using PostgreSQL and working with Distributed Database. - Proficient in Postgres Database operations, tuning and query optimization. - Familiar with database observability tooling and establishing best practices around health metric. - Familiar with AWS Aurora or RDS. - Entrepreneurial Drive: You like to work in public, own problems end-to-end, and move with intentional speed - so your best ideas ship fast and make a visible dent. - Obsessed with Winning: Everyone at Air plays to win, says the hard thing, and progresses every day while building genuine relationships. Requirements - Act like a driver: Take initiative and ownership without waiting to be told. - Work in public: Share ideas openly, get feedback early, and collaborate across teams. - Play to win: Aim high and bring creativity, adaptability, and focus to your work. - Say the hard thing: Give and receive feedback with clarity and respect. - Disagree and commit: Debate honestly, then align quickly to move forward together. Benefits - Join a rapidly scaling company with a mission to transform the creative ops space. Your work will have a direct, tangible impact on [our ARR growth]. - We offer competitive medical, dental, and vision insurance, along with dependent coverage. - You’ll also enjoy a generous work-from-home stipend, professional development reimbursement, and unlimited vacation days. - We believe in the power of diverse perspectives and strive to create an inclusive culture that welcomes individuals from all backgrounds and experiences. - If based in the US, the compensation range for this role is USD $160,000 to $240,000. - If based in Canada, the compensation range for this role is CAD $165,000 to $248,000.

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description This position can be supported remotely. Implements and maintains operation and physical design of diverse databases. Conducts performance tuning of indexes, optimization of storage functionality (i.e. compression techniques or cloud offerings), and databases in general. Reviews database design and integration of systems, provides backup recovery, clones, and makes recommendations regarding enhancements and/or improvements. Maintains security and integrity controls. Formulates and implements policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. - Design, implement, and manage scalable database architectures using PostgreSQL and Azure Database services, ensuring high availability, security, and compliance. - Develop and optimize complex SQL queries, stored procedures, and scripts to support data analysis, reporting, and ETL processes. - Administer and troubleshoot databases on Linux servers, including performance tuning, backup/recovery strategies, and system monitoring. - Integrate DevOps principles into database workflows, including CI/CD pipelines, automation scripting, and infrastructure as code (IaC) using tools like Terraform or Ansible. - Participate in Agile ceremonies (e.g., sprints, stand-ups, retrospectives) to collaborate with development, operations, and product teams on data-driven projects. - Conduct database performance audits, identify bottlenecks, and implement optimizations to improve query efficiency and system reliability. - Mentor junior team members on best practices in database management, cloud integration, and DevOps tools. - Ensure data governance, security protocols, and disaster recovery plans align with industry standards and organizational needs. - Stay current with emerging technologies in cloud databases, open-source tools, and Agile/DevOps methodologies to recommend improvements. Qualifications - Proven expertise in Microsoft Azure, including Azure SQL Database, Azure PostgreSQL, and related services like Azure Data Factory or Synapse Analytics. - Strong proficiency in PostgreSQL, including schema design, indexing, partitioning, and advanced querying techniques. - Advanced SQL skills for data manipulation, analysis, and optimization in large-scale environments. - Hands-on experience with Linux operating systems, including shell scripting, system administration, and troubleshooting in production environments. - Demonstrated experience working in Agile environments, with tools like Jira, Scrum, or Kanban. - Solid understanding of DevOps practices, including automation, version control (e.g., Git), containerization (e.g., Docker), and orchestration (e.g., Kubernetes). - Excellent problem-solving skills, with the ability to analyze complex data issues and implement effective solutions. - Strong communication skills to articulate technical concepts to non-technical stakeholders. Requirements - Bachelor's degree in related field and minimum of 10+ years of experience in a related or applicable field, or an equivalent combination of education and experience. Benefits - Competitive pay and benefits packages. - Health care, dental, vision, life insurance. - 401(k). - Education assistance. - Paid time off including PTO, holidays, and any other paid leave required by law. EEO Statement ASRC Federal and its Subsidiaries are Equal Opportunity employers. All qualified applicants will receive consideration for employment without regard to race, gender, color, age, sexual orientation, gender identification, national origin, religion, marital status, ancestry, citizenship, disability, protected veteran status, or any other factor prohibited by applicable law.

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description Join our Technology Team as a Senior Database Administrator located in various offices. We are seeking a professional who thrives in a fast-paced, deadline-driven environment. - Responsible for architecting, administering and optimizing all enterprise SQL Server databases - Ensures security, reliability, and scalability of databases - Collaborates with application owners and IT teams to support business operations - Provides technical guidance to users accessing enterprise data Key Responsibilities - Maintains all enterprise SQL database operations including SQL server updates and patches - Maintains database security and compliance with company, industry and government standards (GDPR, HIPAA, etc.) - Reviews current architecture and updates and optimizes all the firm's enterprise database systems - Architects and implements new database systems - Proactively monitors database performance and performs database tuning for optimal performance - Troubleshoots enterprise database servers and related systems - Supports system audits and provides documentation as required - Plans testing and implementation of DR and backup processes to ensure continuous operation - Creates custom queries, data-driven SSRS subscriptions, migration scripts, and executes other tasks as needed Qualifications - Bachelor's degree or equivalent work experience - Minimum 8 to 10 years’ experience in design, development, administration, and maintenance of enterprise-level MS SQL Server database systems - Demonstrable experience configuring, operating and maintaining Microsoft SQL Server, both on-prem and cloud environments - Demonstrable experience in database design, creating standards and processes, capacity planning, disaster recovery planning, accessibility, scalability and documentation for SQL Server - Demonstrable experience in development of complex queries, SSIS Packages and SSRS reports Skills & Competencies - Sound understanding of SQL Server technology features and limitations - In-depth, advanced knowledge of SQL Server database structures, security, storage solutions, virtualization, replication, and clustering - Ability to create performance projections based upon hardware, OS, databases design, query structures and interactions between external systems with the database servers - Ability to evaluate and recommend technological changes in the database environment to support business objectives - Proficiency in automation and scripting (e.g., PowerShell) - Strong analytical and troubleshooting skills - Excellent verbal and written communication skills, with an ability to effectively communicate technical details to persons without technical experience - Excellent organizational and interpersonal skills - Excellent attention to detail and problem-solving skills - Ability to accurately follow documented procedures and a strong aptitude for learning new technologies as they are incorporated into the computing environment Company Description GT is an EEO employer with an inclusive workplace committed to merit-based consideration and review without regard to an individual’s race, sex, or other protected characteristics and to the principles of non-discrimination on any protected basis.

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description The Database Administrator will be responsible for maintaining existing databases and designing new database solutions. - Maintain existing database (SQL Server (primary), MySQL, Postgres) - Design and implement new database solutions - Work in an area of growth opportunity for SS&C and our client Qualifications - High level of energy and passion - Strong sense of professional accountability and integrity - Good inter-personal, verbal and written communication skills - An aptitude for problem solving, crisis management, and time management - 5+ years MS SQL Server Administration experience required - Strong technical knowledge in software development methodologies, design patterns, and implementation - Strong experience as a Database Administrator (DBA) with responsibilities spanning both Application DBA and Production Support DBA roles - Hands-on experience working in private cloud environments or major cloud platforms such as AWS or Azure Requirements - Experience with SQL Server, MySQL, and Postgres - Ability to design and implement database solutions Benefits - Hybrid Work Model & a Business Casual Dress Code, including jeans - 401(k) Matching Program, Professional Development Reimbursement - Flexible Personal/Vacation Time Off, Sick Leave, Paid Holidays - Medical, Dental, Vision, Employee Assistance Program, Parental Leave - Committed to Celebrating the Variety of Backgrounds, Talents, and Experiences of Our Employees - Hands-On, Team-Customized Training, including SS&C University - Discounts on fitness clubs, travel, and more