Software Engineers (Job code PRD002)

As a Software Engineer at AH Infotech, your main responsibilities will include designing and developing database objects and stored procedures in our Media and Entertainment system. You will work with technologies such as Sybase IQ, Oracle, and PL/SQL while also ensuring that database performance is optimized through testing and tuning.

To qualify for the Software Engineer role at AH Infotech, you must possess a Bachelor’s Degree in Computer Science, Computer Engineering, or Software Engineering. A strong knowledge of Algorithm & Data Structures, Data Mining, and Systems Programming is also necessary.

Yes, the Software Engineer position at AH Infotech requires 100% travel to unanticipated client locations throughout the USA. This is an essential part of the job as you will be working closely with our clients to deliver tailored solutions.

A Software Engineer at AH Infotech should be proficient in several key programming languages and tools, including Cryptography, Sybase IQ 12/15, Oracle 12c, PL/SQL, Shell Scripting, and various database development tools such as Toad and SQL Developer.

In the Software Engineer role at AH Infotech, you may face challenges related to database performance and troubleshooting bugs. You'll need to analyze complex problems and identify root causes, developing effective solutions under potentially tight deadlines, particularly when working with client projects.

When designing stored procedures, I focus on understanding the application's requirements first. I ensure that the procedures are efficient, maintainable, and well-documented. I also consider edge cases and security practices such as input validation and error handling.

Performance tuning is crucial as it helps optimize database operations, ensuring that queries run efficiently and resources are used effectively. This leads to improved application performance, reduced load times, and better user experiences, which are paramount in high-demand environments like Media and Entertainment.

I utilize a systematic approach for troubleshooting database bugs, starting with replication of the issue to understand its context. I then analyze logs, review error messages, and use debugging tools to pinpoint the root cause, ensuring that my debugging process is thorough and methodical.

I stay updated by following major industry publications, participating in online forums, and attending webinars or conferences. Networking with other professionals and enrolling in relevant courses also helps me keep my skills current.

In a previous project, I used data mining techniques to analyze customer behavior for a retail client. I applied algorithms to uncover trends, which provided actionable insights that informed their marketing strategy and significantly increased their engagement rates.

I have applied cryptography principles in various database applications to secure sensitive data. This includes implementing encryption algorithms for data at rest and in transit, ensuring compliance with data protection regulations, and mitigating security risks.

I prioritize tasks and set clear timelines for each project. Effective time management and communication are key aspects of handling multiple projects. I also regularly assess progress and adjust priorities as needed to meet deadlines.

I have worked with Sybase IQ primarily for analytical queries in data warehousing environments. I leverage its column-based storage capabilities for high-performance analytics, ensuring efficient data retrieval and processing, especially for complex queries.

I have extensive experience with PL/SQL, where I've developed numerous stored procedures, functions, and triggers to automate database functions, optimize queries, and improve overall system efficiency.

In addition to technical skills, I believe strong communication skills, teamwork, and adaptability are essential. Being able to collaborate with team members and clients and to adapt to changing project requirements can significantly impact project success.