Job description
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.