Database Administrator

Intelliswift Software - Dublin, CA

Full-time - Mid Level

Dublin, CA

Professional, Scientific, and Technical Services

About the position

As a Database Administrator at Intelliswift Software, you will play a crucial role in managing and optimizing our database systems to support various data-driven initiatives. You will work closely with a team of passionate data engineers and scientists to enable advanced data mining, deep learning, statistical modeling, predictive analytics, machine learning, and natural language processing (NLP). Your expertise in database structures, theories, principles, and practices will be essential in ensuring the reliability and performance of our database environments. In this role, you will be responsible for the configuration, implementation, and maintenance of relational databases, with a strong focus on Microsoft SQL Server and Snowflake. You will demonstrate your expertise in relational database administration, including performance tuning, disaster recovery planning, and high availability strategies. Your ability to troubleshoot and optimize database performance will be critical in supporting our production activities, particularly during month-end and year-end processes. You will also be accountable for identifying and tracking all databases by function, owner, and application, ensuring that business-critical databases are well-documented and maintained. Your collaboration with developers will be key in resolving database/application issues while adhering to best practices. Additionally, you will support SQL databases in external cloud environments and participate in a 24/7 on-call rotation to address any issues that arise in both production and non-production settings.

Responsibilities

• Work with a team of passionate data engineers and scientists to enable data mining, deep learning, statistical modeling, predictive analytics, machine learning, and NLP.
• Provide day-to-day support and maintenance for existing SQL databases.
• Identify and track all databases by function, owner, and application that are business critical.
• Assist in the administration, management, and monitoring of all SQL database systems.
• Ensure proper backup and disaster recovery procedures and documentation are in place.
• Proactively identify bottlenecks and resolve them quickly through performance tuning.
• Collaborate with developers on performance tuning, query optimization, and index tuning.
• Support SQL database in external cloud environments and work with various cloud providers as required.
• Rotate with other DBAs to be on call for production and non-production environments.

Requirements

• Bachelor's degree in Computer Science, Information Systems or related field.
• 5+ years of SQL DBA experience.
• Advanced SQL and PL/pgSQL programming skills.
• Strong understanding of database architecture and performance tuning.
• Experience with disaster recovery planning and implementation for MSSQL Server.
• Proficient in scripting and automation.
• Experience working with machine learning experts and data scientists.
• Strong communication skills and ability to direct other DBAs.
• Experience with Snowflake or other BI applications.

Nice-to-haves

• Experience with machine learning and AI data products.
• Knowledge of reporting and query tools and practices.
• Experience with large enterprise database performance tuning.