Database Programmer/Developer

Responsibilities:

• Developing Oracle PL/SQL or SQL Server Packages/Procedures/Functions that include collections, ref-cursors to pass the data between Java applications/Reports and the database.
• Gather and analyze requirements from business users and create functional specifications and design documents.
• Create and maintain data loads and business rules.
• Fine Tune SQL queries for better application and system performance.
• Maintain existing programs using Python, Java, HTML/CSS and JSP a plus
• Monitoring and support of the US Servers.
• Monitoring, support for DBMoto.
• Prior to server patching activities, developer needs to stop, restart and monitor DBMoto after patching activities have been completed.
• Escalation to DBMoto 3rd party vendor support if needed.
• Monitoring and support of the US Datamart.
• MS Windows Management.
• Power Shell and MS SQL Script and API creation or updates as needed or requested for US Servers, Datamart, PowerBI environment.
• Angular development tasks for RRM, TRT, and Dharmony applications.
• Non-SCCM reporting requests to add/modify data in the Datamart.
• Monitoring, support for DBMoto.
• Prior to server patching activities, developer needs to stop, restart and monitor DBMoto after patching activities have been completed.
• Escalation to DBMoto 3rd party vendor support if needed.
• MS Windows Management(Plus).

Qualifications:

• Degree in Computer Science, Engineering, or relevant degree.
• Proven years of experience as an SQL Developer or similar role.
• Excellent understanding of T-SQL programming and Microsoft SQL Server.
• Good knowledge of Python, HTML and JavaScript.
• Experience with SQL Server Reporting Services, SQL Server Analysis Services, and Transparent Data Encryption (TDE).
• Familiarity with the practical application of NoSQL\NewSQL databases.
• Strong SQL programming skills in Oracle & SQL Server. Knowledge of DB2/UDB2 a plus
• Shell Scripting skills
• Ability to understand and adhere to Information security requirements of the organizations and the specific responsibility assigned.

Compensation

• Competitive salary Total CTC (10,00,000 to 18,00,000) Per Annum
• Training
• Opportunity for advancement
• Fun and exciting environment.