8+ years of database development experience, with 3-5 years specifically in Kinetica DB
In-depth knowledge of Kinetica's in-memory architecture
Proven expertise in performance tuning within Kinetica
Extensive experience with Kinetica's native features, including UDFs in Python/Java
Strong SQL skills and understanding of data warehousing principles
Proficiency in Python or Java for scripting and automation
Experience with shell scripting in Linux/Unix environments
Responsibilities
Design and implement scalable database solutions using Kinetica
Develop and maintain complex SQL queries and User Defined Functions (UDFs)
Identify and resolve performance bottlenecks proactively
Lead query tuning and database configuration efforts
Utilize Kinetica's native features for geospatial and graph analytics
Manage data models and oversee data ingestion pipelines
Create and maintain custom runbooks for database operations
Benefits
Opportunities for professional development and mentorship
Collaborative work environment with data scientists and analysts
Access to cutting-edge database technologies
Potential for involvement in innovative projects
Flexible work arrangements
Full Job Description
Role description
Job Title: Sr.DATA Migration Developer
Work Location Irving TX
Job Description:
Kinetica Database Architecture Design Architect design and implement robust scalable and high-performance database solutions using Kinetica
Development Implementation Develop and maintain complex SQL queries and User Defined Functions UDFs to support application requirements
Performance Optimization Proactively identify and resolve performance bottlenecks
Lead efforts in query tuning resource management and database configuration to ensure optimal performance and efficiency
Native Feature Utilization Serve as the subject matter expert on Kineticas native features including geospatial analysis graph analytics GSQL and timeseries functions
Drive the adoption and implementation of these features to solve complex business problems
Data Modeling Ingestion Design and manage data models and schemas Implement and oversee efficient data ingestion pipelines into the Kinetica database
Operational Excellence Create and maintain custom runbooks for database monitoring troubleshooting backup and recovery procedures Automate routine operational tasks
Collaboration Work closely with data scientists' application developers and business analysts to understand their data needs and provide effective database solutions
Mentorship Provide technical guidance and mentorship to junior members of the team on Kinetica best practices
Required Skills and Qualifications Technical Skills
Experience of 8 years of experience in database development with at least 3-5 years of Handson experience with Kinetica DB
Kinetica Expertise
In-depth knowledge of Kineticas in memory Unaccelerated architecture
Proven expertise in performance tuning and optimization within the Kinetica environment
Extensive experience with Kineticas native features including
User Defined Functions UDFs in Python Java
Advanced geospatial queries and visualization
Graph analytics and GSQL
Timeseries data handling
Proficiency in Kinetica administration monitoring and security management
Database Proficiency
Expert level SQL skills
Strong understanding of data warehousing principles, ETL processes and data modeling techniques
Experience with other in memory databases eg SAP HANA MemSQL Redis is a significant plus
Programming Scripting
Proficiency in Python or Java for scripting automation and UDF development
Experience with shell scripting in a Linux Unix environment
