Database Architect

at Grand Hyper

Posted by Rahul Malani

Responsibilities Ensure timely and top-quality product delivery Ensure that the end product is fully and correctly defined and documented Ensure implementation/continuous improvement of formal processes to support product development activities Drive the architecture/design decisions needed to achieve cost-effective and high-performance results Conduct feasibility analysis, produce functional and design specifications of proposed new features. · Provide helpful and productive code reviews for peers and junior members of the team. Troubleshoot complex issues discovered in-house as well as in customer environments. Qualifications · Strong computer science fundamentals in algorithms, data structures, databases, operating systems, etc. · Expertise in Java, Object Oriented Programming, Design Patterns · Experience in coding and implementing scalable solutions in a large-scale distributed environment · Working experience in a Linux/UNIX environment is good to have · Experience with relational databases and database concepts, preferably MySQL · Experience with SQL and Java optimization for real-time systems · Familiarity with version control systems Git and build tools like Maven · Excellent interpersonal, written, and verbal communication skills · BE/B.Tech./M.Sc./MCS/MCA in Computers or equivalent

ITTStar global services is subsidiary unit in Bengaluru with head office in Atlanta, Georgia. We are primarily into data management and data life cycle solutions, which includes machine learning and artificial intelligence. For further info, visit ITTstar.com . As discussed over the call, I am forwarding the job description. We are looking for enthusiastic and experienced data engineers to be part of our bustling team of professionals for our Bengaluru location. JOB DESCRIPTION: 1. Experience in Spark & Big Data is mandatory. 2. Strong Programming Skills in Python / Java / Scala /Node.js. 3. Hands on experience handling multiple data types JSON/XML/Delimited/Unstructured. 4. Hands on experience working at least one Relational and/or NoSQL Databases. 5. Knowledge on SQL Queries and Data Modeling. 6. Hands on experience working in ETL Use cases either in On-premise or Cloud. 7. Experience in any Cloud Platform (AWS, Azure, GCP, Alibaba). 8. Knowledge in one or more AWS Services like Kinesis, EC2, EMR, Hive Integration, Athena, FireHose, Lambda, S3, Glue Crawler, Redshift, RDS is a plus. 9. Good Communication Skills and Self Driven - should be able to deliver the projects with minimum instructions from Client.

Roles and Responsibilities: Design Stored Procedures, Views, Functions, triggers, indexes, constraints etc. Develop complex SQL code using joins, subqueries and troubleshoot the SQL code. Integration of multiple data sources and databases into one system. Build clean and reusable SQL queries for future use. Improve the performance and optimise SQL queries to get best results. Work with team members on design of software systems and support to development team. Establish processes and best practices with defined database standards. Skills / competencies: Extensive experience working with enterprise applications using relational databases (Postgresql is preferred). Strong knowledge and experience in query optimisation, performance tuning, using SQL profiler, Performance monitor and related monitoring tools. Experience developing complex queries, Stored Procedures, Views, Functions, Triggers and troubleshooting the same. Familiarity with RDBMS principles, normalisation, database design is an added advantage. Understanding of the fundamental design principles behind a scalable application. Special Requirements: 5+ years experience in SQL development, performance tuning and query optimisation. Strong analytical, problem solving, English communication skills, both written and spoken. Knowledge of PHP/ Laravel will be an added advantage. Experience with enterprise-scale systems a major plus.

Job Description Mandatory: ☞ Deep knowledge in a programming language, ideally Python ☞ Deep knowledge selenium, numpy, openpyxl, beautifulsoup, pandas, and sklearn ☞ Knowledge of at least one web framework, ideally a Python-friendly one e.g. Django, Flask, Pyramid ☞ Ability to extract multiple sources and conduct heavy treatment to a wide array of tables ☞ Familiarity with event-driven and object-oriented programming ☞ Ability to integrate multiple data sources and databases into one system ☞ Understanding of fundamental design principles for scalable applications Preferred: ☞ High proficiency with at least one code repository ☞ Experience leading and managing deadlines and responsibilities for own work You will be expected to: ☞ Understand existing overall architecture and improve it according to the latest standards and best practices, e.g. existing Extract Treat Load scripts ☞ Using best practice such as code reviews, push – pull, agile development methods ☞ Quickly improve overall quality of code with the development of automated testing We are also working on some exciting Machine Learning applications that you can join if interested.

We are looking to hire outstanding individual to join our Engineering team to manage and support the database infrastructure. What is the job like? *Manage Postgres server database product lifecycle in production and pre-production environments. *Monitor system health and performance and ensure high performance, availability and security. *Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations. *Independently analyze, solve and correct issue on high priority. *Assist developer with complex query tuning and schema. *Provide 24x7 support for the production database and help in outage resolution. What do we look for? *4+ years of strong experience with Performance tuning and optimization. *Experience in High Availability, maintenance and Disaster Recovery plans. *Good understanding and experience in Backup, restore and recovery models.