7 Db Design Jobs

You should have a strong development knowledge in DB Design & development with 6+ to 10 years of experience in Postgres DB. It is mandatory to have hands-on experience in writing complex PGSQL procedures and Functions to prevent blocking and Deadlocks. Conducting SQL objects code review and Performance tuning is also mandatory. Having proficiency in Microsoft SQL and MYSQL DB will be an advantage. A strong understanding of RDBMS and NoSQL concepts with logical thinking and problem-solving skills is highly required. Expertise in transaction databases (OLTP) and ACID property with the ability to manage large-scale application databases is mandatory. Your key responsibilities will include designing, implementing, and maintaining scalable and efficient PostgreSQL databases. You will be responsible for developing database schemas, tables, views, and relationships based on application requirements. Writing complex SQL queries, stored procedures, and functions to support various applications will be part of your role. Identifying and resolving issues related to blocking and deadlocks in database operations, conducting thorough code reviews of SQL objects, and optimizing performance are essential tasks. You will need to provide insights into integration and data migration between different database systems and design strategies to handle large-scale application databases effectively. Consulting with application developers to offer expert guidance on SQL and PGSQL best practices, and maintaining clear and comprehensive documentation for database structures, procedures, and configurations are key aspects of the role. Strong communication skills are crucial for effectively conveying technical information to both technical and non-technical stakeholders.,

The Applications Development Manager position is an intermediate management role where you will be responsible for leading and directing a team of employees to establish and implement new or improved application systems and programs, in collaboration with the Technology team. Your main objective will be to oversee applications systems analysis and programming activities. Your responsibilities will include conducting tasks such as feasibility studies, time and cost estimates, IT planning, risk technology assessment, applications development, and establishing new or revised applications systems and programs to meet specific business needs. You will also be monitoring and controlling all phases of the development process, providing user and operational support on applications, and utilizing your specialty knowledge to analyze complex problems and provide evaluative judgments. Additionally, you will recommend and develop security measures post-implementation, consult with users/clients and technology groups, recommend advanced programming solutions, and ensure essential procedures are followed. You will also serve as an advisor to new or lower-level analysts, operate with a limited level of direct supervision, and act as a subject matter expert to senior stakeholders and team members. Qualifications for this role include at least 8 to 11 years of hands-on application development experience. The primary skill set required includes Java 17, Spring Boot 3.0, PL/SQL (Oracle 19c), DB Design and Optimization, Microservices (Spring Boot), Web services, Design Patterns, Kafka, and Elasticsearch. It would be beneficial to have knowledge of Spark, Nodejs, Jenkins, OpenShift, Autosys, Angular 14+, and JavaScript. Experience in systems analysis, software application programming, microservice development, distributed system design, managing successful projects, and working under pressure is essential. The ideal candidate will possess a Bachelor's degree or equivalent experience. This job description is a high-level overview of the responsibilities involved, and other duties may be assigned as needed.,

At Citi, we are not just building technology, we are building the future of banking. Encompassing a broad range of specialties, roles, and cultures, our teams are creating innovations used across the globe. Citi is constantly growing and progressing through our technology, with a laser focus on evolving the ways of doing things. As one of the world's most global banks, we are changing how the world does business. Shape your Career with Citi We are currently looking for a high-caliber professional to join our team as an Officer, Oracle Database Developer-C10- Hybrid based in Pune, India. Being part of our team means that we will provide you with the resources to meet your unique needs, empower you to make healthy decisions and manage your financial well-being to help plan for your future. In this role, you are expected to: Responsibilities: - Write code on one or more development platforms to deliver part or all of a feature, under guidance from senior engineers. - Respond to problems, questions, or situations by applying established criteria to directly influence development outcomes. Use the right technology to solve technical challenges required to deliver all or part of small-scale features and functions and/or supporting aspects of larger program efforts. - Have responsibility for applications systems analysis and programming activities that may include inputs to feasibility studies, time and cost estimates, and implementation of new or revised applications systems and programs. - Accountable for development, design, construction, testing, and implementation and write secure, stable, testable, and maintainable code. - Operate with autonomy, while some oversight and direction may be required. - Engage in digital applications development, risk technology, Middleware, Mainframe applications, Non-Mainframe applications, Analytic Model Development, and Application support activities to meet specific business needs of user areas and to test systems to ensure the integrity of deliverables. - Expected to provide a sound understanding of application development concepts and principles and a basic knowledge of concepts and principles in other technology areas. - On occasion, may need to consult with users, clients, and other technology groups on issues and recommend programming solutions for customer exposed systems. - Understand the functionality of the systems involved with projects, including the applications/services, runtime operations, and maintenance. - Understand the business context and the associated customer use cases. - Understand your technologies for your features and are able to evaluate system designs and architecture while participating in solution discussions, development, and the creation of application/systems documentation. - Participate in design sessions to gain an understanding of the context for design decisions and provide inputs for making these design decisions. - Expected to seek guidance from peers and/or manager for items not outlined in our operating procedures. - Provide inputs for building project development schedules. - Provide inputs for feature prioritization, highlight technical dependencies between deliverables, and help the scrum team reach consensus with the product owner. - Verbal and written communication is clear and concise. Qualifications: - 2 - 4 years of experience in Oracle, PLSQL concepts, database, Agile framework. - Experience in Jira, GitHub, Good command on DB design and review. - Relevant experience in the Financial Service industry. - Intermediate level experience in Applications Development role. - Consistently demonstrates clear and concise written and verbal communication. - Demonstrated problem-solving and decision-making skills. Education: - Bachelors/University degree or equivalent experience. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity, review Accessibility at Citi. View Citi's EEO Policy Statement and the Know Your Rights poster.,

The Applications Development Senior Programmer Analyst position is an intermediate level role where you will be responsible for participating in the establishment and implementation of new or revised application systems and programs in collaboration with the Technology team. Your main objective will be to contribute to applications systems analysis and programming activities. Your responsibilities will include conducting tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, and model development. You will also establish and implement new or revised applications systems and programs to meet specific business needs or user areas. Monitoring and controlling all phases of the development process, including analysis, design, construction, testing, and implementation, will be part of your role. Additionally, you will provide user and operational support on applications to business users. Your expertise in applications development will be crucial in analyzing complex problems/issues, evaluating business process and system process, and adhering to industry standards. You will also recommend and develop security measures in post-implementation analysis to ensure successful system design and functionality. Collaborating with users/clients and other technology groups on issues, recommending advanced programming solutions, and providing assistance on customer exposure systems will be part of your responsibilities. Ensuring essential procedures are followed, defining operating standards and processes, and serving as an advisor or coach to new or lower-level analysts will also be expected from you. You should be able to operate with a limited level of direct supervision, exercise independence of judgment and autonomy, and act as a subject matter expert to senior stakeholders and/or other team members. It is essential to assess risks when making business decisions, considering the firm's reputation and safeguarding Citigroup, its clients, and assets. Compliance with applicable laws, rules, and regulations, ethical judgment, and transparency in escalating, managing, and reporting control issues will be critical aspects of your role. Qualifications: - Primary Skill Set: Java 17, Spring Boot 3.0, Angular 14+, JavaScript, PL/SQL (Oracle 19c), DB Design and Optimization - Experience in full stack software solutions development involving front end, middleware, and backend - Experience in agile projects, DevOps practices, and CI/CD pipelines - Good verbal communication skills - Strong problem-solving skills and attention to detail - Proactive working attitude, quick learning ability, ownership, responsibility, good communication skills, and team spirit - 5-8 years of relevant experience in systems analysis and programming of software applications - Experience in managing and implementing successful projects - Working knowledge of consulting/project management techniques/methods - Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements Education: - Bachelor's degree/University degree or equivalent experience This job description provides a comprehensive overview of the responsibilities and qualifications for the Applications Development Senior Programmer Analyst position. Other job-related duties may be assigned as required.,

1. Strong development knowledge in DB Design & development with 6+ Years to 10 Years experience (Postgres DB) Mandatory 2. Strong hands on writing complex PGSQL, procedure and Functions & prevent blocking and Deadlocks 3. Conduct SQL objects code review & Performance tuning( Mandatory ) 4. having hands on Microsoft SQL and MYSQL DB is an advantage. 5. Strong knowledge in RDBMS and NoSQL Concept with strong logical thinking and solutions (Highly required) 6. Expert in transaction databases (OLTP) and ACID property with handling large scale application databases(Mandatory) 8. Consult application developer to provide suggestion / SQL's / PGSQLs on DB with best solutions 9. Good Communications and written skills

Job Summary We are looking for a skilled PHP Developer with 2+ years of experience to design, develop, and maintain web applications. The ideal candidate should have strong expertise in PHP, MSSQL, and modern frameworks (Laravel, CodeIgniter). You will collaborate with cross-functional teams to deliver scalable and efficient solutions. Key Responsibilities Develop, test, and maintain PHP-based web applications. Write clean, secure, and efficient PHP code following best practices. Integrate MSSQL databases and optimize queries for performance. Work with RESTful APIs and third-party services. Troubleshoot, debug, and upgrade existing systems. Follow MVC architecture and OOP principles. Collaborate with frontend developers to integrate UI elements. Implement security measures to protect against vulnerabilities (e.g., SQL injection, XSS). Use Git/SVN for version control in a team environment. Required Skills & Qualifications 2+ years of professional PHP development experience. Strong knowledge of PHP 8, MSSQL, and database design. Experience with at least one PHP framework (Laravel/CodeIgniter). Understanding of HTML5, CSS3, JavaScript (jQuery, React is a plus). Familiarity with RESTful APIs, JSON, and AJAX. Basic knowledge of Linux/Unix server environments. Experience with Git, SVN, Composer, and dependency management. Problem-solving skills and attention to detail. Ability to work independently and in a team.

Tech Lead to spearhead design & dev of cutting-edge software solutions for Advanced Traffic Management Systems (ATMS). Design & develop scalable web Apps using Microsoft technologies. Integrate APIs & ensure high-quality, reliable & secure solutions. Required Candidate profile B. Tech/ MCA, 6+ Yrs exp, coding, debugging, C#, LINQ, MVC 5, .Net Core, Bootstrap, CSS, Ajax, Jquery, Angular, JavaScript, REST API, Web Services, WPF, OOPS, MongoDB/ MYSQL DB Design, Index & tables