Job Title: PL/SQL developer
Location: Hyderabad
Experience: 3 - 5 Years
Need a 3yrs hands on experience PL/SQL for client request and ready to work in client place.
Candidate should possess the following set of skills and knowledge: 1. SQL Language Proficiency: A strong understanding of Structured Query Language (SQL) is essential. Should be familiar with SQL concepts like querying, data manipulation, and data definition. 2. Database Design and Modeling: Proficiency in designing and modeling databases is crucial. Should be able to create efficient and well-structured database schemas, tables, indexes, and relationships. 3. Oracle & MS SQL Server: In-depth knowledge and experience working with Oracle DB & Microsoft SQL Server, including the latest versions. Familiarity with various features and components of SQL Server, such as stored procedures, triggers, functions, and views, is important. 4. T-SQL: Thorough knowledge of Transact-SQL (T-SQL), the Oracle SQL Server implementation of SQL. Should be proficient in writing complex queries, optimizing query performance, and understanding TSQL programming constructs. 5. Database Administration: Understanding of database administration tasks, including security management, user management, backup and recovery, monitoring, and performance tuning. 6. Query Optimization: Ability to analyze and optimize SQL queries for improved performance. Familiarity with query execution plans, indexing strategies, and performance tuning techniques is valuable. 7. Data Integration: Experience in integrating data from various sources using SQL Server Integration Services (SSIS) or other ETL (Extract, Transform, Load) tools. 8. Reporting and Analysis: Knowledge of reporting and analysis tools such as SQL Server Reporting Services (SSRS), Power BI, or other similar tools to create meaningful reports and visualizations. 9. Troubleshooting and Debugging: Proficiency in identifying and resolving database-related issues, debugging stored procedures, and optimizing database performance. 10. Version Control: Familiarity with version control systems, such as Git, to manage and track database schema changes and scripts. 11. Security and Compliance: Understanding of database security best practices, including authentication, authorization, and data encryption. Awareness of regulatory compliance requirements, such as IRDAI, is beneficial. 12. Scripting and Automation: Ability to write scripts using PowerShell, Python, or other scripting languages to automate routine tasks, perform data transformations, or deploy database changes. 13. Collaboration and Communication: Strong collaboration and communication skills to work effectively in a team, gather requirements, and communicate technical concepts to non-technical stakeholders. 14. Continuous Learning: Being proactive in keeping up with the latest developments, trends, and best practices in PL/SQL Server and database technologies