Intellibus · 12 hours ago
Lead Database Administrator
New York, United States
Full-time
Remote
Senior Level, Lead/Staff
10+ years exp
Maximize your interview chancesInformation Technology & Services
Insider Connection @Intellibus
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
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 client’s 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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor's degree in Computer Science or a related field
10–15 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
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
Preferred
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.)
Company
Intellibus
We are a team of passionate software engineers and entrepreneurs. We love to solve challenging problems efficiently.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase
