4 Database Apps Jobs

Working Hours : 2PM to 11PM/AM IST Responsibilities : - Lead and execute database migration projects from on-premises or other cloud environments to Oracle Cloud and GCP, ensuring a smooth and efficient transition. - Perform detailed assessments of existing database environments, plan migration strategies, and execute migrations while minimizing impact on business operations. - Work closely with cloud architects, IT security, and operations teams to design and implement scalable, secure, and highly available database solutions on OCI and GCP. - Optimize database performance by implementing best practices for cloud environments, including cost optimization, scalability, and disaster recovery strategies. - Ensure data integrity, security, and compliance with relevant regulations and standards during and after the migration process. - Develop and maintain documentation for database architectures, migration processes, and operational procedures. - Provide technical expertise and support for database design, deployment, management, and troubleshooting in cloud environments. - Collaborate with application development teams to ensure optimal database performance and integration with cloud-native services. - Keep abreast of new features and technologies within OCI and GCP to enhance database capabilities and performance. - Conduct training and knowledge-sharing sessions for the IT team on cloud database technologies and best practices. Required Skills and Qualifications : - Bachelor's degree in computer science, Information Technology, or a related field. - Proven experience as a DBA with a focus on database migration projects to cloud platforms, specifically Oracle Cloud and Google Cloud Platform. - Strong understanding of database structures, theories, principles, and practices. - Familiarity with Oracle Database, MS SQL, MySQL, PostgreSQL, and other relational database management systems (RDBMS). - Mainly we are looking for DBA who has hands on experience in migrating Databases (Oracle Database, MySQL, PostgreSQL, MSSQL) from on-prem to Cloud - Experience with cloud services related to databases in OCI and GCP, such as Oracle Autonomous Database, Google Cloud SQL, and Google Cloud Spanner. - Knowledge of cloud security, networking, and infrastructure as it relates to database services. - Proficiency in database scripting and automation tools for migration and maintenance tasks. - Excellent problem-solving, project management, and communication skills. - Certifications in Oracle Cloud and Google Cloud Platform are highly desirable. Additional Requirements : - Availability to work outside of standard business hours as needed for migrations and maintenance windows. - Willingness to learn new technologies and adapt to changing environments.

Role Overview :The ideal candidate will have hands-on experience and an SME in maintaining databases, with a primary focus on performance, optimization, troubleshooting, high availability, disaster recovery, and automation. With deep expertise in Open Database technologies of PostgreSQL, Redis and MongoDB with additional expertise in containerization and orchestration tools like Docker and Kubernetes. Key Responsibilities :1. Database Maintenance & Administration : - Perform routine maintenance tasks including backup, recovery, patching, and performance tuning. - Conduct standard database maintenance and administration tasks with attention to detail. - Monitor database activity, health, and performance, using database management system software and tools to collect performance statistics. - Optimize database performance, plan for forecast resource needs, and recommend corrective actions. - Ensure database high availability, replication, failover, and clustering. - Develop and configure tools to automate database administration tasks, enhancing efficiency and minimizing downtime. - Maintain procedures and documentation for databases, ensuring compliance with standards for definition, security, and integrity of database objects. - Implement disaster recovery strategies and maintain data integrity across environments.2. Incident Management & Troubleshooting : - Handle critical escalations and complex troubleshooting for database issues. - Diagnose performance bottlenecks, slow queries, deadlocks, and replication issues. - Collaborate with DevOps, infrastructure, and application teams for RCA (Root Cause Analysis).3. Backup, Recovery & Disaster Recovery : - Design and implement backup strategies and disaster recovery plans. - Ensure data integrity, redundancy, and compliance with RPO/RTO requirements.4. Containerization & Orchestration : - Manage databases using Docker and Kubernetes to ensure scalability and resilience. - Optimize containerized database solutions for performance optimization. - Implement CI/CD pipelines for automated deployment and maintenance of databases within containerized environments.5. Collaboration & Communication : - Work closely with application teams to ensure seamless integration and optimal performance by understanding business logic, data models, and query patterns. - Optimize database schema and queries for application performance improvement. - Interact with customers, suppliers, and partners to deliver effective database maintenance.6. Documentation & Reporting : - Maintain comprehensive documentation of database architectures, processes, maintenance plans, and troubleshooting guides. - Prepare reports detailing system health, performance metrics, and improvement plans. Required Skills and Qualifications : - Database Technologies : Deep knowledge of PostgreSQL, Redis and MongoDB. - Containerization & Orchestration : Hands-on experience with Docker and Kubernetes for deploying and managing databases. - Infrastructure and Application Integration : Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows. - Performance Tuning & Optimization : Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms.

Job Title : PostgreSQL Database Developer Position : Postgres Database Developer Key Skills : Postgresql, Pl/SQL Education Qualification : Any Graduate Minimum Years of Experience : 4+ Years Type of Employment : Permanent Requirement : Immediate or Max 15 days Location : Bangalore Job Description : Our dynamic and growing company is actively seeking an experienced PostgreSQL Database Developer to join our team. As a PostgreSQL Database Developer, you will play a crucial role in designing, implementing, and maintaining our database systems .The ideal candidate should have a strong background in database development, performance optimization, and data modeling. Job Responsibilities : - Responsible to design, implement, and maintain database schemas in PostgreSQL and perform data modeling to ensure efficiency, reliability, and scalability. - Responsible to optimize and tune SQL queries for improved performance , and also identify and resolve performance bottlenecks in database systems. - Responsible to manage data migration and integration processes between different systems and ensure data consistency and integrity during the migration process. - Responsible to develop and maintain stored procedures, functions, and triggers to support application requirements - Implement business logic within the database layer. Responsible to Implement and maintain database security policies and manage user roles, permissions, and access control within the database. - Responsible to implement and oversee database backup and recovery processes and also ensure data availability and reliability. - Responsible to collaborate with cross-functional teams, including application developers, system administrators, and business analysts, to understand database requirements. - Responsible to create and maintain documentation related to database design, processes, and best practices. Qualifications : - Bachelor's degree in Computer Science, Information Technology, or a related field. - Proven experience as a Database Developer with a focus on PostgreSQL. - In-depth knowledge of database design principles, normalization, and data modeling. - Strong proficiency in writing and optimizing SQL queries. - Experience with performance tuning and query optimization techniques. - Familiarity with database security best practices and access control. - Hands-on experience with data migration, integration, and ETL processes. - Proficiency in scripting languages (e.g., Python, Bash) for automation tasks. - Knowledge of backup and recovery processes. - Excellent communication and collaboration skills. - Ability to work independently and as part of a team. Preferred Skills: - Experience with PostgreSQL replication and clustering. - Familiarity with NoSQL databases. - Knowledge of cloud database solutions (e.g., AWS RDS, Azure Database for PostgreSQL). - Understanding of DevOps practices and tools.

Purpose : Administers and maintains multiple high-availability database servers and database services supporting various HMI systems. Establishes positive working relationships within IT, the business partners and with other functional areas of the company. Utilizes technical expertise to define, design and implement database solutions within functional area(s) of responsibility. Establishes and maintains priorities for projects and simultaneous assignments. Implements, monitors and enforces data security controls and measures to ensure integrity and high availability of database systems. Manages, mentors, guides and instructs team members of work delivery, prioritization and capacity planning. This role extends beyond geographical boundaries as it aims to support the Herman Miller business across the globe and involves some amount of travel and flexible working in shift rotations, extended hours and weekend coverage to ensure business is supported. Responsibilities : - Ensure security and SOX requirements are adhered to and respond to audits as required. - Complete the periodic internal SOX Audits ensuring Documented evidence and IPE is maintained. - provide effective ERP and DBA support across the international sites. - Manage SQL Server databases - Configure and maintain database servers and processes - Monitor system's health and performance - In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration - In charge of database migrations and server updates - Ensure high levels of performance, availability, sustainability and security - Analyze, solve, and correct issues in real time - Provide suggestions for solutions - Refine and automate regular processes, track issues, and document changes - Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible. - Assist developers with query tuning and schema refinement - Provide 24x7 support for critical production systems - Perform scheduled maintenance and support release deployment activities after hours - Participate in continuous process improvement - Make recommendations for system architecture per Microsoft SQL Server best practices - Ensures that the infrastructure is built-out for High Availability, Recoverability, DR, and Performance. - Ensures integration of enterprise application and database performance, monitoring and altering management systems. - Manage the periodic refresh and ad-hoc refresh of test and Stage Environments - Upgrade ERP systems and apply patches as required - Provide Support for the development teams in US, UK, India and APAC Minimum Requirements : - Bachelor's / Master's Degree in Computer Science or equivalent - One or more technical certifications on Database management / administration preferably coupled with certification in Windows server administration. - 6 years of hands-on database administration experience with Microsoft SQL in large multi-server multi-location enterprise environments (including virtualized environments). - Excellent interpersonal skills. Strong oral and written communication skills to work closely with internal customers (IT and users) and third party vendors - Strong analytical and problem solving skills with attention to detail. - Ability to view opportunities and solutions from a broad, long term perspective. - Good working knowledge of SQL 2016,2019 with experience on SSRS, SSIS, SSMS - Good working knowledge of SQL Security - Knowledge of Windows operating systems: 2016,2019 - Knowledge of VM and SAN database optimization - Proactive, methodical and willing to own and resolve issues - A team player with the ability to work on their own - Able to work to tight deadlines - Able to work closely with the leadership to design, implement and improve processes regularly Essential Experience : - Database Administration experience of at least 6 years in a busy commercial and enterprise environment - Certification in Microsoft SQL server administration (2014 and above) - SQL Profiler&Tuning skills - Experience of database replication, mirroring or log shipping - SQL Security management - Experience of managing small team of DBAs - Experience of Business Application Administration and support. - Clear, confident communication skills - Experience building and maintaining a strategic plan. Desirable : - Experience of Infor Syteline ERP system - This is highly desirable - Certification in Oracle Database Administration (Preferred) - Foglight / SpotlightonSQLServer, SharePoint, Red-Gate - Exposure to SOX and ITIL