SQL Database Development Data Modeling Project Management
• Collaborate with customers, project management, software engineering, and network operations teams for database requirements to enhance existing systems and design new systems • Install new and upgrade existing systems • Enforce database security, standards, and guidelines • Support and design 24x7 high availability solutions • Database and server performance: analyze, configure, and monitor physical server hardware, operating system, and database software for optimal configuration of settings, data access patterns, disk I/O performance, etc., and provide recommendations for upgrades and new systems • Database development: queries, stored procedures, ETL, testing, code reviews, code optimizations, and index tuning • Validate, plan, and execute database schema and code changes, bottleneck analysis, outage prevention/resolution, server/database performance improvements, database recovery, and restores • Planning for system growth • Ensuring compliance with vendor license agreements • Various reporting and data exportation and importation including CSV, XML, and unstructured formats • Document the database environment, processes, and best practices • Provide technical support and problem resolution • Production / On-Call Support
• Bachelor’s Degree in Information Technology or a similar field • At least 5 years of experience with DB2 • At least 2 years of experience with PostgreSQL • Extensive knowledge of SQL • Data modeling • Performance analysis tuning • Experience with 24x7 transaction processing systems • Good problem-solving skills with attention to detail, analytical, administrative, organizational, communication, and interpersonal skills • Good at English (both verbal and written)
• Benefits will be shared in details for successful candidates
• Experience in NoSQL • Experience with Docker and Kubernetes • Experience with migration tools (ora2pg, Full Convert, Sqlines, etc.) • Experience in in-memory databases (Redis)