Intellibus
Lead Database Administrator
Intellibus, Reston, Virginia, United States, 22090
Are you a Database Administrator (DBA) working at a Large Financial Institution and being told by your leadership that you are too hands on or detail oriented or think and work like a start-up?
Imagine working at
Intellibus
to engineer platforms that impact billions of lives around the world. With your passion and focus we will accomplish great things together! We are looking forward to you joining our Platform Engineering Team. Our Platform Engineering Team is working to solve the Multiplicity Problem. We are trusted by some of the most reputable and established FinTech Firms. Recently, our team has spearheaded the Conversion & Go Live of apps which support the backbone of the Financial Trading Industry. We are looking for Engineers who can Database Configuration & Management Review and assess the overall database configuration, including clustered environments, disk space, memory allocation, and backup strategies. Ensure proper configuration of backup time, location, retention policies, and validate the backup strategy aligns with Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO). Indexing & Query Optimization Analyze indexing strategies, identifying unused, clustered, or composite indexes, and propose optimizations based on application workload (read-heavy vs. write-heavy). Identify and resolve indexing issues, such as missing indexes on primary and foreign keys, and optimize database performance through query refinements. Disaster Recovery & High Availability Evaluate and document the clients disaster recovery (DR) plans, ensuring the latest DR tests are conducted, documented, and aligned with business continuity objectives. Assess failover automation and manual failover documentation for robustness and reliability. Identify and mitigate single points of failure, ensuring reliable crossover mechanisms between master and standby nodes for high availability. Bottleneck Identification & Database Optimization Conduct performance reviews to identify and address query and database bottlenecks, especially related to read/write operations. Evaluate the appropriateness of the database model (e.g., RDBMS vs. NoSQL) and recommend optimizations for auto-growth, auto-shrink, and resource utilization settings. Schema & Query Review Perform detailed reviews of database schemas, entity-relationship diagrams (ERD), and version control for schema changes. Ensure that all database keys (primary, foreign) are in place, and review query execution plans for optimization opportunities. Metrics & Performance Monitoring Analyze database performance metrics, including throughput, query execution time, concurrency, and overall resource utilization. Provide ongoing monitoring and reporting to senior leadership on database health and performance. Backup & Recovery Testing Ensure comprehensive backup and recovery plans are in place and perform regular recovery drills to verify backup integrity. Confirm backup SLAs are documented, and that backups are regularly tested by restoring them to a test server. Client Interaction & Stakeholder Management Work directly with senior management and client stakeholders to present findings, make recommendations, and provide regular updates on database health and performance. Lead meetings and presentations with a clear, concise, and results-driven approach, ensuring alignment with client objectives. Qualifications Bachelor's degree in Computer Science or a related field is preferred. Experience: 1015 years of hands-on experience in database administration, focusing on large-scale, high-availability systems, and enterprise-level database environments (SQL Server, Oracle, MySQL, PostgreSQL, etc.). Database architecture and clustering configurations Backup and disaster recovery strategies Performance tuning and query optimization Indexing strategies, schema design, and entity-relationship modeling High-availability solutions and failover strategies NoSQL and RDBMS databases Database monitoring and metric analysis Proven ability to communicate complex technical concepts to non-technical senior management and stakeholders. Experience in presenting findings and technical recommendations clearly and persuasively. Strong interpersonal skills, with the ability to engage effectively with both technical teams and business executives. Demonstrated experience developing, testing, and validating disaster recovery plans. Knowledge of RTO and RPO metrics, and practical experience with failover automation and manual recovery processes. Certification in database technologies (e.g., Microsoft Certified: Azure Database Administrator, Oracle DBA, etc.). Familiarity with cloud-based database environments (AWS RDS, Azure SQL, etc.). Experience with performance monitoring and database optimization tools (e.g., SQL Profiler, Query Analyzer, SolarWinds, etc.). Analytical: Strong problem-solving skills with the ability to analyze database issues from both a technical and business perspective. Leadership: Ability to lead technical discussions and guide teams toward solutions in a collaborative, efficient manner. Client-Focused: Understanding of client needs, with the ability to manage expectations and deliver value in a customer-centric manner. Proactive: Always looking for opportunities to improve processes, performance, and efficiency within the data layer. We work closely with Oracle Database MySQL PostgreSQL MongoDB ETL Processes Google Cloud Platform (GCP) AWS NoSQL Databases Load Balancing Jenkins (CI/CD) UNIX/Linux Our Process Schedule a 15 min Video Call with someone from our Team 4 Proctored GQ Tests ( 30-45 min Final Video Interview Receive Job Offer If you are interested in reaching out to us, please apply and our team will contact you within the hour.
Intellibus
to engineer platforms that impact billions of lives around the world. With your passion and focus we will accomplish great things together! We are looking forward to you joining our Platform Engineering Team. Our Platform Engineering Team is working to solve the Multiplicity Problem. We are trusted by some of the most reputable and established FinTech Firms. Recently, our team has spearheaded the Conversion & Go Live of apps which support the backbone of the Financial Trading Industry. We are looking for Engineers who can Database Configuration & Management Review and assess the overall database configuration, including clustered environments, disk space, memory allocation, and backup strategies. Ensure proper configuration of backup time, location, retention policies, and validate the backup strategy aligns with Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO). Indexing & Query Optimization Analyze indexing strategies, identifying unused, clustered, or composite indexes, and propose optimizations based on application workload (read-heavy vs. write-heavy). Identify and resolve indexing issues, such as missing indexes on primary and foreign keys, and optimize database performance through query refinements. Disaster Recovery & High Availability Evaluate and document the clients disaster recovery (DR) plans, ensuring the latest DR tests are conducted, documented, and aligned with business continuity objectives. Assess failover automation and manual failover documentation for robustness and reliability. Identify and mitigate single points of failure, ensuring reliable crossover mechanisms between master and standby nodes for high availability. Bottleneck Identification & Database Optimization Conduct performance reviews to identify and address query and database bottlenecks, especially related to read/write operations. Evaluate the appropriateness of the database model (e.g., RDBMS vs. NoSQL) and recommend optimizations for auto-growth, auto-shrink, and resource utilization settings. Schema & Query Review Perform detailed reviews of database schemas, entity-relationship diagrams (ERD), and version control for schema changes. Ensure that all database keys (primary, foreign) are in place, and review query execution plans for optimization opportunities. Metrics & Performance Monitoring Analyze database performance metrics, including throughput, query execution time, concurrency, and overall resource utilization. Provide ongoing monitoring and reporting to senior leadership on database health and performance. Backup & Recovery Testing Ensure comprehensive backup and recovery plans are in place and perform regular recovery drills to verify backup integrity. Confirm backup SLAs are documented, and that backups are regularly tested by restoring them to a test server. Client Interaction & Stakeholder Management Work directly with senior management and client stakeholders to present findings, make recommendations, and provide regular updates on database health and performance. Lead meetings and presentations with a clear, concise, and results-driven approach, ensuring alignment with client objectives. Qualifications Bachelor's degree in Computer Science or a related field is preferred. Experience: 1015 years of hands-on experience in database administration, focusing on large-scale, high-availability systems, and enterprise-level database environments (SQL Server, Oracle, MySQL, PostgreSQL, etc.). Database architecture and clustering configurations Backup and disaster recovery strategies Performance tuning and query optimization Indexing strategies, schema design, and entity-relationship modeling High-availability solutions and failover strategies NoSQL and RDBMS databases Database monitoring and metric analysis Proven ability to communicate complex technical concepts to non-technical senior management and stakeholders. Experience in presenting findings and technical recommendations clearly and persuasively. Strong interpersonal skills, with the ability to engage effectively with both technical teams and business executives. Demonstrated experience developing, testing, and validating disaster recovery plans. Knowledge of RTO and RPO metrics, and practical experience with failover automation and manual recovery processes. Certification in database technologies (e.g., Microsoft Certified: Azure Database Administrator, Oracle DBA, etc.). Familiarity with cloud-based database environments (AWS RDS, Azure SQL, etc.). Experience with performance monitoring and database optimization tools (e.g., SQL Profiler, Query Analyzer, SolarWinds, etc.). Analytical: Strong problem-solving skills with the ability to analyze database issues from both a technical and business perspective. Leadership: Ability to lead technical discussions and guide teams toward solutions in a collaborative, efficient manner. Client-Focused: Understanding of client needs, with the ability to manage expectations and deliver value in a customer-centric manner. Proactive: Always looking for opportunities to improve processes, performance, and efficiency within the data layer. We work closely with Oracle Database MySQL PostgreSQL MongoDB ETL Processes Google Cloud Platform (GCP) AWS NoSQL Databases Load Balancing Jenkins (CI/CD) UNIX/Linux Our Process Schedule a 15 min Video Call with someone from our Team 4 Proctored GQ Tests ( 30-45 min Final Video Interview Receive Job Offer If you are interested in reaching out to us, please apply and our team will contact you within the hour.