Principal Database Architect
About The Position
In our ‘always on’ world, we believe it’s essential to have a genuine connection with the work you do. Vistance Networks PKI Center is seeking a Principal Database Architect to join our team in San Diego, California and help shape the future of device and software security at global scale. As we expand our customer base and accelerate the growth of our PKI and security services, you will lead the architecture and evolution of the high-performance, highly scalable database platforms that power our mission-critical infrastructure. If you are passionate about building robust data systems, solving complex technical challenges, and making a lasting impact in device and software security, we invite you to join us on our journey to become a leader in the security services industry.
Requirements
- Bachelor's degree in Computer Science, Computer Engineering, or a related field.
- 10+ years of Microsoft SQL Server database administration experience in a complex enterprise environment.
- Strong knowledge of relational databases, T-SQL, database design, normalization, and data modeling.
- Experience with database performance tuning, query optimization, indexing, troubleshooting, backup and recovery, HA/DR, replication, and SQL Server maintenance.
- Experience developing and supporting SSIS packages, ETL workflows, data migration, data integration, and data lifecycle management processes.
- Experience with reporting platforms such as SSRS, SSAS, Power BI, or similar tools.
- Experience supporting physical and virtual Windows Server environments.
- Strong analytical, problem-solving, communication, and organizational skills.
- Ability to work independently and manage multiple priorities.
Nice To Haves
- Experience with PostgreSQL and SAP SQL Anywhere (Sybase).
- Experience with Python, PowerShell, Bash, or other scripting languages.
- Experience with monitoring and observability tools such as Elasticsearch, SolarWinds, Wavefront, Grafana, or similar platforms.
- Experience with cloud database technologies, including Azure SQL, AWS RDS, or similar solutions.
- Experience evaluating and implementing database replication, synchronization, and modernization initiatives.
Responsibilities
- Administer and maintain SQL Server environments across production, development, test, and disaster recovery environments.
- Monitor database performance, availability, capacity, and security; troubleshoot and resolve operational issues.
- Manage backups, restores, patching, upgrades, migrations, replication, and disaster recovery processes.
- Develop, maintain, and optimize SSIS packages supporting ETL, data integration, synchronization, migration, and lifecycle management activities.
- Review database designs and provide recommendations on data modeling, schema design, indexing, and query optimization.
- Develop and maintain stored procedures, scripts, and deployment packages supporting application releases and system enhancements.
- Design and support reporting, data management, and high-availability database solutions.
- Research and evaluate database technologies, replication methods, and platform improvements to enhance scalability, reliability, and performance.
- Partner with development, QA, infrastructure, and business teams to support application, integration, and reporting requirements.
- Design secure, scalable, and highly available database architectures that meet current and future business needs.
Benefits
- The range can be higher for candidates with exceptional experience and a demonstrated history of successful performance.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Principal
