Position Overview: The DevOps Engineer is responsible for bridging the gap between software development and IT operations. This role involves implementing continuous integration and continuous deployment (CI/CD) pipelines, automating infrastructure, ensuring reliable system performance, and enhancing the overall development and deployment process.

Key Responsibilities:

1. Infrastructure as Code (IaC):

   • Develop and maintain infrastructure using tools like Terraform, CloudFormation, or Ansible.
   • Manage cloud-based environments (AWS, Azure, GCP) and on-premises servers.

2. Continuous Integration and Continuous Deployment (CI/CD):

   • Design, implement, and manage CI/CD pipelines using tools like Jenkins, GitLab CI, CircleCI, or Azure DevOps.
   • Automate build, test, and deployment processes to ensure fast, reliable delivery of software.

3. Monitoring and Logging:

   • Set up and maintain monitoring, logging, and alerting solutions using tools like Prometheus, Grafana, ELK Stack, or Datadog.
   • Ensure systems are monitored for performance, reliability, and availability.

4. Collaboration and Communication:

   • Work closely with development teams to integrate DevOps practices and tools.
   • Facilitate cross-team collaboration to improve development and deployment workflows.

5. Security and Compliance:

   • Implement security best practices in DevOps processes, including secret management, vulnerability scanning, and automated compliance checks.
   • Collaborate with security teams to ensure the infrastructure and applications meet security standards.

6. Automation and Scripting:

   • Write scripts and automation tools to improve operational efficiency and reduce manual tasks (e.g., Bash, Python, or PowerShell).
   • Develop automation workflows for various operational tasks.

7. Configuration Management:

   • Use configuration management tools (e.g., Ansible, Chef, Puppet) to manage and deploy software configurations across environments.
   • Maintain and manage configuration consistency across all environments.

8. System Administration:

   • Perform server management, patching, and troubleshooting.
   • Ensure system performance and availability, including backup and recovery planning.

9. Containerization and Orchestration:

   • Develop and manage containerized applications using Docker, Kubernetes, or similar technologies.
   • Optimize container environments for scaling, reliability, and performance.

10. Documentation:

    • Maintain clear and concise documentation of system configurations, automation scripts, CI/CD pipelines, and operational procedures.

Qualifications:

• Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience).
• 3+ years of experience in DevOps, System Administration, or Software Engineering.
• Proficiency in CI/CD tools (Jenkins, GitLab CI, CircleCI, Azure DevOps, etc.).
• Strong experience with cloud platforms (AWS, Azure, GCP) and IaC tools (Terraform, CloudFormation, Ansible).
• Solid scripting skills (Bash, Python, PowerShell).
• Experience with containerization (Docker) and orchestration (Kubernetes) tools.
• Familiarity with monitoring and logging tools (Prometheus, Grafana, ELK Stack, Datadog).
• Understanding of security best practices in DevOps environments.
• Excellent problem-solving skills and a proactive approach to identifying and resolving issues.
• Strong communication and collaboration skills.

Preferred Qualifications:

• Certifications in cloud platforms (AWS Certified DevOps Engineer, Azure DevOps Engineer, etc.).
• Experience with microservices architecture and serverless computing.
• Knowledge of networking concepts and security protocols.
• Experience with agile methodologies and tools (e.g., Jira, Confluence).

Benefits:

• Competitive salary and performance-based bonuses.
• Health, dental, and vision insurance.
• Flexible working hours and remote work options.
• Opportunities for professional development and certifications.
• Collaborative and inclusive work environment.

Would you like any modifications or additions?

Job Description: PL/SQL Developer

Position Overview: The PL/SQL Developer is responsible for designing, developing, and maintaining complex database-driven applications using Oracle PL/SQL. This role involves writing efficient and optimized SQL queries, stored procedures, functions, and packages to support the business needs, ensuring data integrity, performance, and reliability.

Key Responsibilities:

1. PL/SQL Development:

   • Design, develop, and maintain PL/SQL scripts, procedures, functions, packages, and triggers to support application development.
   • Write efficient and optimized SQL queries for data extraction, manipulation, and reporting.

2. Database Design and Management:

   • Collaborate with database administrators (DBAs) to implement and maintain database structures, including tables, indexes, views, and materialized views.
   • Participate in data modeling and database schema design activities.

3. Performance Tuning:

   • Analyze and optimize SQL queries and PL/SQL code to enhance performance.
   • Use tools like Oracle SQL Profiler, Explain Plan, and SQL Trace to identify and resolve performance bottlenecks.

4. Application Support and Troubleshooting:

   • Provide support for existing applications, including troubleshooting and resolving issues related to PL/SQL code and database performance.
   • Collaborate with developers and analysts to understand requirements and deliver solutions.

5. Data Integrity and Security:

   • Ensure data integrity, consistency, and accuracy through effective use of constraints, triggers, and stored procedures.
   • Implement and maintain data security measures, including user roles, privileges, and access controls.

6. Documentation:

   • Create and maintain technical documentation, including design specifications, data flow diagrams, and coding standards.
   • Document all changes made to database structures and PL/SQL code.

7. Collaboration:

   • Work closely with business analysts, developers, and testers to understand requirements, develop solutions, and ensure successful implementation.
   • Participate in code reviews and provide constructive feedback to peers.

8. Testing and Validation:

   • Develop and execute unit tests for PL/SQL code to ensure accuracy and performance.
   • Support QA teams in functional testing, performance testing, and troubleshooting.

9. Continuous Improvement:

   • Identify areas for improvement in existing PL/SQL code and recommend changes to enhance performance and maintainability.
   • Stay updated with the latest Oracle technologies, features, and best practices.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3+ years of experience in PL/SQL development with Oracle databases.
• Proficient in writing complex SQL queries, stored procedures, functions, packages, and triggers.
• Strong experience with Oracle database management and optimization tools (e.g., Oracle SQL Developer, Toad, SQL*Plus).
• Solid understanding of data modeling, relational database design, and normalization.
• Experience with performance tuning and query optimization.
• Familiarity with data warehousing concepts and ETL processes.
• Strong problem-solving skills and attention to detail.
• Excellent communication and interpersonal skills