8 Backup Strategies Jobs

Description We are seeking a skilled Mainframe CICS Administrator to join our team in India. The ideal candidate will have extensive experience in managing CICS environments and ensuring optimal performance of mainframe applications. Mainframe CICS Admin The ideal candidate for this role will have the below experience and qualifications: 1. Support the operations of the Mainframe CICS infrastructure. 2. Responsible for carrying out BAU tasks for application owners. These include CICS resource definitions online(terminals, programs, bundles etc.), defining new CICS regions , Define zCEE servers , Angle Servers etc. 3. Good knowledge on monitoring and administrative tools like Sysview, Omegamon , CAFC or any other equivalent for support. 4. Experience in upgrade of CICS TS from lower version to higher version. 5. Knowledge on CICS Transaction Gateway and CICS webservices and CICSplex Operations 6. Experience in vendor product install / upgrade and applying PTF for maintenance 7. Support and document DR processes 8. Monitor ticketing tool to resolve incidents and requests within agreed SLAs. 9. Problem determination skills demonstrating independence and experience in troubleshooting, researching, and resolving complex issues, showing strong ability to utilize system diagnostics to arrive at problem solutions. 10. Ability to work off hours and weekends to support change implementation. Ability to support client systems in a 24/7 on- call rotation. 11. CICS SSL Setup Troubleshooting 12. Should be able to understand the CICS Application Architecture and troubleshoot issues arising due to incoming CICS connections from Offhost DataPower , WAS etc. 13. Experience in CICS Monitoring Tools - CA SYSVIEW / Omegamon / Mainview etc. 14. Well versed with setting up architecture for CICSPLEX Setup , CMAS, WUI and MRO region Setup and troubleshoot related issues at system level . 15. Incident Management , Change Management on Service Now , BMC Remedy On Demand Tool.

Job Description: As a Senior Database Administrator, you will be responsible for managing and maintaining highly available EDB PostgreSQL and MySQL database environments. Your role will include database architecture design, performance tuning, replication setup, backup and recovery, and ensuring data security. You will also provide expertise in cloud migrations and ensure database environments meet high availability and disaster recovery requirements. Key Responsibilities: Database Management: Install, configure, and maintain EDB PostgreSQL and MySQL databases. Manage database schemas, perform upgrades, and apply patches. Monitor database health, availability, and performance across multi-node clusters. Ensure high availability and disaster recovery setups using replication, clustering, and failover mechanisms. Performance Tuning and Optimization: Conduct performance tuning and optimization for SQL queries, indexes, and overall database design. Monitor and optimize resource utilization (CPU, memory, storage) for both EDB PostgreSQL and MySQL. Troubleshoot and resolve performance bottlenecks and database-related application issues. Backup and Recovery: Implement robust backup strategies, including full, incremental, and point-in-time backups. Plan and perform database recovery operations to ensure minimal data loss. Use tools such as pgBackRest, WAL archiving, MySQL dump, and physical and logical backup techniques. Replication and Clustering: Set up and maintain replication (e.g., streaming replication, logical replication) and clustering solutions. Configure and manage failover solutions to enhance database resilience and availability. Administer and troubleshoot EDB Postgres Advanced Server tools like EFM (EDB Failover Manager), PG Pool, and PG Bouncer. Database Security and Compliance: Implement security best practices, including role-based access control and encryption. Ensure compliance with regulatory and security standards. Manage user access and permissions securely. Database Cloud Migration: Lead cloud migration projects to AWS, GCP, or Azure. Design and implement strategies for minimal-downtime migrations. Leverage cloud-native features to optimize performance and scalability. Automation and Scripting: Develop and maintain scripts for database automation tasks using Bash, Python, or SQL. Use monitoring tools and write custom scripts to proactively identify issues. Collaboration and Documentation: Work closely with development teams to optimize database interactions. Document database architectures, processes, configurations, and troubleshooting guidelines. Provide training and guidance to junior DBAs. Technical Skills: Database Platforms: EDB PostgreSQL, PostgreSQL, MySQL. Tools: pgBackRest, WAL, pgBouncer, PG Pool, PEM, MySQL Workbench, MySQL replication, EFM, and monitoring tools like Zabbix, Nagios, or Prometheus. Scripting: Proficiency in SQL, Bash, Python, or other automation languages. Cloud Platforms: AWS, GCP, Azure (experience with cloud-specific database services preferred). Security: Strong knowledge of database security protocols and compliance standards. Operating Systems: Linux (preferably Ubuntu, CentOS, or RHEL) and Windows Server. Soft Skills: Strong problem-solving and analytical skills. Effective communication and teamwork abilities. Proactive approach to learning and applying new technologies. Occasional on-call availability for emergency troubleshooting and support. Education: BE OR BTech or MCA or MTech only Interview Rounds: 2 or 3 Technical rounds Experience Level: 6 to 10 Years

Key Skills and Responsibilities Snowflake Architecture: Deep understanding of Snowflake's architecture, components, and functionalities. Snowflake cost model: Understanding of how Snowflake cost model operates and ability to improve efficiency and track costs across the platform. Database Management: Expertise in creating, managing, and optimizing databases, schemas, tables, and views. Data Modeling: Knowledge of dimensional modeling (star and snowflake schemas) for data warehousing. Data Warehousing: Knowledge of data warehousing concepts, methodologies, and best practices. SQL: Proficiency in SQL for querying, manipulating, and analyzing data. Performance Optimization: Understanding of performance tuning techniques (clustering, materialized views, warehouse sizing) to improve query performance. Security: Expertise in implementing security measures (IAM, role-based access control, data encryption, password rotation processes) to protect sensitive data. ETL/ELT Tools: Familiarity with ETL/ELT tools (e.g., HVR, SnapLogic) for data loading and transformation. Cloud Computing: Understanding of cloud concepts (e.g., scalability, elasticity, resource management) and experience with cloud platforms (AWS, Azure). Scripting: Proficiency in scripting languages (e.g., Python, Bash) for automation and data processing tasks. Reporting platform: Experience in setting up Power BI workspaces and Cognos Packages with secure data models ready for reporting. Project Management: Knowledge of project management methodologies (e.g., Agile, Waterfall) and tools. Other Skills Problem-Solving: Ability to troubleshoot and resolve technical issues efficiently. Communication: Effective communication skills to interact with stakeholders and team members. Analytical Thinking: Ability to analyze data and identify patterns and trends. Attention to Detail: Meticulous approach to ensure data accuracy and integrity. Adaptability: Willingness to learn new technologies and adapt to changing requirements. Project Management: Ability to plan, execute, and monitor projects effectively. Leadership: Ability to lead and motivate project teams. Time Management: Effective time management skills to meet project deadlines. Adaptability: Flexibility to adapt to changing project requirements. Stakeholder Management: Ability to manage expectations and build relationships with stakeholders.

Key Skills and Responsibilities Snowflake Architecture: Deep understanding of Snowflake's architecture, components, and functionalities. Snowflake cost model: Understanding of how Snowflake cost model operates and ability to improve efficiency and track costs across the platform. Database Management: Expertise in creating, managing, and optimizing databases, schemas, tables, and views. Data Modeling: Knowledge of dimensional modeling (star and snowflake schemas) for data warehousing. Data Warehousing: Knowledge of data warehousing concepts, methodologies, and best practices. SQL: Proficiency in SQL for querying, manipulating, and analyzing data. Performance Optimization: Understanding of performance tuning techniques (clustering, materialized views, warehouse sizing) to improve query performance. Security: Expertise in implementing security measures (IAM, role-based access control, data encryption, password rotation processes) to protect sensitive data. ETL/ELT Tools: Familiarity with ETL/ELT tools (e.g., HVR, SnapLogic) for data loading and transformation. Cloud Computing: Understanding of cloud concepts (e.g., scalability, elasticity, resource management) and experience with cloud platforms (AWS, Azure). Scripting: Proficiency in scripting languages (e.g., Python, Bash) for automation and data processing tasks. Reporting platform: Experience in setting up Power BI workspaces and Cognos Packages with secure data models ready for reporting. Project Management: Knowledge of project management methodologies (e.g., Agile, Waterfall) and tools. Other Skills Problem-Solving: Ability to troubleshoot and resolve technical issues efficiently. Communication: Effective communication skills to interact with stakeholders and team members. Analytical Thinking: Ability to analyze data and identify patterns and trends. Attention to Detail: Meticulous approach to ensure data accuracy and integrity. Adaptability: Willingness to learn new technologies and adapt to changing requirements. Project Management: Ability to plan, execute, and monitor projects effectively. Leadership: Ability to lead and motivate project teams. Time Management: Effective time management skills to meet project deadlines. Adaptability: Flexibility to adapt to changing project requirements. Stakeholder Management: Ability to manage expectations and build relationships with stakeholders.

We are seeking an experienced SQL Developer to join our dynamic team in India. The ideal candidate will have extensive experience in SQL development, database management, and a deep understanding of data structures and optimization techniques. Responsibilities Design, develop, and maintain SQL databases and applications. Write complex SQL queries for data retrieval and analysis. Optimize SQL queries for performance improvements. Collaborate with application developers to integrate SQL databases with applications. Ensure data integrity and security in SQL databases. Monitor and troubleshoot database performance issues. Perform database backups and recovery as needed. Skills and Qualifications 10-15 years of experience in SQL development and database management. Proficient in SQL and experience with various database systems (e.g., MySQL, SQL Server, Oracle). Strong understanding of database design principles and normalization. Experience with performance tuning and optimization of SQL queries. Familiarity with database backup and recovery techniques. Ability to write efficient and effective stored procedures, triggers, and functions. Knowledge of data modeling and ETL processes. Experience with version control systems and collaborative development tools.

Coordinating, analyzing, designing, implementing and administering solutions. Recommending best practices for improvements to current operational processes. Configuring and maintaining SQL Server database servers. Troubleshooting operational problems. Administering proactive daily checks. Responding to monitoring alerts. Communicating status and planning activities to customers and other team members. Participating in the teams rotational shift pattern and on-call coverage rotation plan. What do we need from you 3 years or more of experience as a SQL Server DBA Installing, configuring and upgrading SQL Server databases. SQL Server Administration including: Managing Server and Database storage. Performance tuning of database server. Designing and implementing various backup/recovery strategies. SSRS & Power BI, SSIS, and BI experience. Coding scripts, procedures, functions, etc.

What you will be doing: You'll work closely with the customer teams to understand their needs, in both a project based and long term support capacity. You'll create and document database standards, create optimized queries, indexes, and data structure. Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support. Use database vendor provided tools and Pythian developed accelerators to performance tune various database systems, specific queries and applications scenarios. Diagnose and address database performance issues using performance monitors and various tuning techniques. Identify areas of opportunity and recommend appropriate improvement suggestions. Work with our site reliability engineering organization to help configure and deploy high-availability and disaster recovery solutions for critical applications to meet customers needs. Cross-functional training in Mongo, Ansible and Python are encouraged. When you're not fixing things, you'll be authoring new blog posts on interesting topics for our open-source community to digest, creating new articles in our customer facing knowledge base for more frequently seen issues, and hosting webinars amongst other things like participating in conferences and meetups promoting Pythian to the open source community. What we need from you: 5-8 years of overall experience required as a Database Consultant (DBC) for this role The position requires specialized knowledge and experience in installing, configuring and upgrading MySQL databases MySQL Administration. Debugging skills, MongoDB and Scripting/automation tooling experience is a huge plus. Strong ability to work in both a team oriented environment and also under minimal supervision. Strong ability to adapt and to learn quickly. Good customer service focus with the ability to handle customer expectations and priorities. Disciplined in their learning process. Self-motivated. Keen attention to detail. Good analytical, evaluative, and problem-solving abilities. Effective organizational skills. Demonstrate sound work ethics. Very good documentation skills. Nice to have - Understanding of current IT service standards such as ITIL. Scripting (bash/python) and Ansible experience is a huge plus. Excellent written and verbal communication skills. Contributor to Open Source projects relevant to MySQL, MongoDB or other database or infrastructure software.

Responsibilities include, but are not limited to: Monitor and maintain office IT infrastructure health including firewall and servers in On Prem Data Centre / offices Managing Cloud Environment (AWS, Azure) Monitoring the logs from Network devices Responsible for compliance activities related to Regulatory guidelines. Involving in IS Audit with Auditors (Internal audit, Regulator audit, Statutory auditors) Involving in Vulnerability Assessment and Penetration Testing related to Infra / Application Coordinating with CISO office and implementing CERT-in alerts and advisories. SOC coordination for security related alerts and remediation. Email server administration (Microsoft 365 Exchange online, Zimbra) Coordinating with Remote Infrastructure Management System / Managed Service Provider partners. Storage devices management (NAS, FTP, SFTP, etc) Microsoft Internet Information Server (IIS) administration, XAMPP, Apache IT Asset management and Stock maintaining. Oversees the required need of hardware and software license and support agreements. Manages all required documentation, as well as reporting and provides delivery according to standards. Assist in providing resolution management to all users technical issues. Monitor and maintain in Windows server (DNS, DHCP, AD) and client administration AD User Management, Antivirus management, Access control management and Desktop level support management LAN/WAN administration Installation, configuration and administration for windows client operating systems. Ensure backup activity and define backup strategies includes application level and database level Develop innovative network troubleshooting methods that reduce downtime and lower repair costs Responsible for creating and administering disaster plans (DR) that will keep the company functional in the event of a crisis. Ensuring RPO/RTO for On Prem and Cloud Applications Determine the rationale and methods for upgrading company network software programs each time an update is released VMWare administration.