Rdbms Jobs in Pune

Introduction In this role, you ll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology. A career in IBM Consulting embraces long-term relationships and close collaboration with clients across the globe. You ll work with visionaries across multiple industries to improve the hybrid cloud and AI journey for the most innovative and valuable companies in the world. Your ability to accelerate impact and make meaningful change for your clients is enabled by our strategic partner ecosystem and our robust technology platforms across the IBM portfolio; including IBM Software Curiosity and a constant quest for knowledge serve as the foundation to success in IBM Consulting. In your role, you ll be encouraged to challenge the norm, investigate ideas outside of your role, and come up with creative solutions resulting in ground breaking impact for a wide network of clients. Our culture of evolution and empathy centers on long-term career growth and development opportunities in an environment that embraces your unique skills and experience. Your Role and Responsibilities As Consultant, you are responsible to develop design of application, provide regular support/guidance to project teams on complex coding, issue resolution and execution. Your primary responsibilities include: Lead the design and construction of new mobile solutions using the latest technologies, always looking to add business value and meet user requirements. Strive for continuous improvements by testing the build solution and working under an agile framework. Discover and implement the latest technologies trends to maximize and build creative solutions. Required Technical and Professional Expertise Mandatory Skills: LUW/Unix DB2 DBA ,Shell Scripting, Linux and AIX knowledge Secondary Skills: Physical DB2 DBA skills, PL/SQL Knowledge and exposure Expert knowledge of IBM DB2 V11.5 installations, configurations administration in Linux /AIX systems. Expert level knowledge in Database restores including redirected restore backup concepts. Excellent understanding of database performance monitoring techniques, fine tuning and able to perform performance checks query optimization Preferred Technical and Professional Expertise Good knowledge of utilities like import, load export under high volume conditions. Ability to tune SQLs using db2advisor db2explain. Ability to troubleshoot database issues using db2diag, db2pd, db2dart, db2top tec.

Position Purpose: Cencora is seeking an Application Development Lead to design, configure, and customize the Archer platform. This role involves leading the configuration of new and existing Archer applications, ensuring the system supports all operational environments, and managing the end-to-end Software Development Life Cycle (SDLC) for Archer applications. Primary Duties & Responsibilities System Support: Ensure adequate system support for components like databases, operating systems, network interfaces, and servers. Lead Administrator: Act as the lead administrator for enterprise applications, resolving system problems and enhancing system functionality. Subject Matter Expert: Serve as a platform expert, educating colleagues on Archer's capabilities and applications, and act as a liaison with IT technical teams. Team Leadership: Provide guidance to Administrators I/II/III for end-user support related to CRM applications. Health & Stability: Maintain the health, availability, and stability of applications and platforms. Change Management: Work with the production team to schedule updates and upgrades, and ensure the appropriate level of testing is conducted before implementing changes. Performance Monitoring: Monitor performance metrics for all system features and identify risks, recommending corrective or preventive actions as needed. Documentation: Prepare documentation for customer support, including software and network configurations. Qualifications & Work Experience Educational Qualifications: Bachelor s degree in Computer Science, Information Technology, or a related field. 6+ years of relevant experience in application support, system administration, or database administration. Technical Lead Experience: Experience working as a technical lead, particularly with RSA and Data fields. Client Interaction & QA Experience: Preferably experienced in client interactions, testing, and quality assurance. Preferred Certifications: Salesforce Certified Administrator Microsoft Certified Systems Administrator (MCSA) ITIL, ITSM Certifications Skills & Knowledge Behavioral Skills: Conflict resolution Creativity & innovation Decision-making Planning & presentation Risk-taking Technical Skills: Identity & Access Management Database Administration IT Support (Software & Hardware Installation, Troubleshooting) Software Validation & Standard Operating Procedure Design Systems Integration IT Regulatory Compliance (e.g., SOX Compliance) Tools & Technologies: Configuration Management: Ansible, Puppet Citrix Technologies: XenDesktop, XenApp, XenServer Operating Systems: Windows, Linux, Citrix, IBM, Oracle, SQL ERP Systems: Sage, ASW, SAP CRM Systems: Salesforce Marketing Cloud, Sales Cloud Java Frameworks: JDBC, Spring, ORM, JPA, JEE, JMS, Gradle RDBMS: Relational Database Management Systems Networking: DNS, HTTP, LDAP, SMTP Qualification : Bachelors degree in computer science, Information Technology or any other related discipline or equivalent related experience.

Job Summary: We are looking for SQL Developer to join our development team. SQL Developer will participate in the design database and tables, implementation, automation, optimization SQL query etc of MySQL infrastructure and operations. Key Responsibilities: Analyze queries and optimize with performance, result. Manage the MySQL database in Linux and Windows. Create a Database table and normalize the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules. Well versed with the DDL and DML statements. Write and optimize in-application SQL statements. Creating and maintaining complex stored procedures, Extended System SP, Triggers, views, Tables, user defined functions. Create indexes and analyze its role for optimizations. Develop Dynamic search queries and results with manipulated data. Ensure performance, security, and availability of databases. Prepare documentations and specifications for Database. Good experience of IT industry with strong understanding of database structures, theories, principles, and practices. Good to have experience in MySQL Database. Deliver top-notch support for all of the MySQL functionality, scalability, availability, performance and reliability for both in-house and cloud deployments. Designing, modelling, developing and supporting Database Management Systems (DBMS). Work with developers to design and optimize SQL queries and schema to participate in application deployments. Create and modify queries, stored procedures and scripts inside of MySQL. Analyzing data requirements, data dictionaries, application and processing architectures, and database schema(s). Then design, develop, amend, optimize, and certify database schema(s) to meet system requirements. Coordinating day-to-day management, support, and troubleshooting activities of the team. Provide database administration support, oversee environment management, monitor database health, resource planning, perform database upgrades and patching, backup/recovery, and make recommendations regarding enhancements and/or improvements. Gather, analyze, and normalize relevant information related to and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Perform duties associated with data stewardship, data security, data integration, and data standards. Database mirroring and replications. Develop and manage daily operational procedures. Contribute to database planning efforts such as disaster recovery design, tool selection, warehousing and scaling initiatives Baseline activities include project management, development of best practices, repeatable procedures for deploying databases, day-to-day operational activities (break/fix, space management, and backup/recovery and database replication setup/management). Create automated processes related to database administration, space management, security, monitoring, and performance. Adhere to all required PCI/SDLC procedures, Ensuring database systems procedures adhere to regulatory requirements. Perform installation, upgrades, and patching of database software. Good interpersonal, written, and oral communication skills. Ability to present ideas in user-friendly language. Self-motivated and directed, with keen attention to detail. Able to prioritize and execute tasks in a high-pressure environment. Experience working in a team-oriented, collaborative environment. Skills: 2+ years in SQL Developer with MySQL Database. Knowledge and experience of MySQL joins, views, indexes, stored procedures, cursors and triggers with a proven track record. Knowledge and experience in managing relational databases. Solid functional experience in Linux and windows. Experience with database performance tuning and capacity planning. Good scripting ability and working knowledge of Shell Scripts. Strong organization, interpersonal, and team-leading skills. Strong multi-tasking abilities, ability to work under pressure, and make priority decisions. Pro-active, dedicated, committed and responsible.