Senior CPLSQL Engineer Remote

Who We Are

Jolera offers MSPs & IT solution providers next-generation managed services, enabling them to create world-class experiences for their clients. Your clients receive award-winning solutions built on over 20 years of experience servicing businesses worldwide. We’ve helped transform hundreds of MSPs & solution providers worldwide! With our collection of tenured experts, we provide an elevated managed service experience for a variety of clients. At Jolera, we treat each MSP partner with specialized care and uniquely organize our products for your individual business needs.

Who You Are

You are a talented Oracle Pro*C and or Oracle SQL Developer to join their application development team. You will be responsible for designing, implementing, and deploying high-performance application code for high-volume real-time transaction processing.

What You’ll Do

You will demonstrate in your day-to-day activities:

• Technical Expertise: Knowledge of SQL Server architecture and the Microsoft Windows operating system.
• Attention to Detail: Precision in implementing changes, updates, and maintaining database security.
• Analytical Skills: Ability to analyze performance metrics and logs to troubleshoot issues and optimize database performance.
• Problem-Solving Skills: Capability to efficiently resolve complex database issues.
• Communication and Collaboration Skills: Effective communication with team members, stakeholders, and management is crucial, especially when explaining technical details in understandable terms. Effectively works well with others to achieve shared objectives.:
• Installation, Configuration, and Upgrading: MS SQL DBAs are responsible for installing and configuring new SQL Server instances according to best practices. This includes setting up database. systems, configuring hardware, and upgrading SQL Server instances to newer versions.
• Performance Tuning and Optimization (PTO): One primary responsibility is ensuring that SQL Server instances run efficiently. This involves monitoring system performance, tuning SQL queries, indexing, and implementing best practices to optimize database and query performance.
• Database Design and Implementation: Although often seen as more of a development role, DBAs may also be involved in database design. This includes designing database schemas, creating tables, indexes, and other database objects, and ensuring the structural integrity of the database.

• Security Management: Ensuring the security of SQL Server databases is paramount. This involves setting up access controls, implementing encryption, managing user permissions, and protecting sensitive data against unauthorized access.

Backup and Disaster Recovery: DBAs implement robust backup strategies and disaster recovery plans. This includes regularly backing up databases, testing backups, and ensuring that disaster recovery procedures are effective in case of data loss or .

Database Maintenance: Routine maintenance tasks such as updating statistics, rebuilding indexes, and checking database integrity are essential for the smooth operation of SQL Server databases. DBAs schedule and automate these tasks to ensure database health.

Troubleshooting and Support: DBAs must quickly diagnose and resolve issues related to SQL Server, such as performance bottlenecks, connectivity issues, and data . Providing support to development teams and end-users is also part of the role.

Capacity Planning: A critical responsibility is to anticipate future database growth and planning for infrastructure needs. This involves monitoring data growth trends and ensuring the database system can scale to meet future demands.

High Availability and Disaster Recovery Setup: Implementing solutions like Always On Availability Groups, Database Mirroring, Log Shipping, or Replication to ensure high availability and disaster recovery readiness.

Qualifications:

• Preferably experience related to migrations especially OCI Migrations (Oracle Cloud
• Infrastructure)
• Degree in Computer Science or equivalent work experience.
• 4 plus years’ relevant
• Previous experience as an Oracle Pro*C developer in a high-volume transaction based processing systems.
• At least 4 years of strong software engineering experience
• 2 years of hands-on scripting and administration or experience with managing middleware application technologies is required ·
• At least 3 years of experience with deployment of enterprise scale software.
• Work closely with Development and QA teams to help ensure end-to-end quality. ·
• Experience delivering solutions using Agile Scrum. ·
• Preferred working knowledge of Git/GitHub Enterprise
• Required knowledge and experience of .Jira/Confluence

What We Offer

Remote work

Competitive compensation & benefits package

Company Perks

Company events, recognitions, and celebrations

Career development and growth opportunities