Principal Software Engineer - IT - India_AGS

ACCOUNTABILITIES: Designs, codes, tests, debugs and documents software according to Dell s systems quality standards, policies and procedures. Analyzes business needs and creates software solutions. Responsible for preparing design documentation. Prepares test data for unit, string and parallel testing. Evaluates and recommends software and hardware solutions to meet user needs. Resolves customer issues with software solutions and responds to suggestions for improvements and enhancements. Works with business and development teams to clarify requirements to ensure testability. Drafts, revises, and maintains test plans, test cases, and automated test scripts. Executes test procedures according to software requirements specifications Logs defects and makes recommendations to address defects. Retests software corrections to ensure problems are resolved. Documents evolution of testing procedures for future replication. May conduct performance and scalability testing. RESPONSIBILITIES: Plans, conducts and leads assignments generally involving moderate, high budgets projects or more than one project. Manages user expectations regarding appropriate milestones and deadlines. Assists in training, work assignment and checking of less experienced developers. Serves as technical consultant to leaders in the IT organization and functional user groups. Subject matter expert in one or more technical programming specialties; employs expertise as a generalist of a specialist. Performs estimation efforts on complex projects and tracks progress. Works on the highest level of problems where analysis of situations or data requires an in-depth evaluation of various factors. Documents, evaluates and researches test results; documents evolution of testing scripts for future replication. Identifies, recommends and implements changes to enhance the effectiveness of quality assurance strategies.

Additional Details

• Description Comments : Roles and Responsibilities (JD)For Oracle DB Essential Requirements Strong proficiency in Oracle PL/SQL:Writing efficient, maintainable stored procedures, functions, packages, and triggers. Experience with SQL and database concepts:Expertise in writing complex SQL queries, optimizing queries, and understanding execution plans. Database design and normalization:Understanding of relational database design principles and normalization techniques. Performance tuning and optimization:Ability to analyze and optimize SQL queries and PL/SQL code for better performance. Experience with Oracle tools:Familiarity with Oracle SQL Developer, TOAD, or similar database development tools. Understanding of transaction management:Knowledge of locking mechanisms, commit, rollback, and concurrency control. Debugging and troubleshooting skills:Ability to identify and resolve database-related issues. Version control systems:Experience using Git, SVN, or other version control tools. Basic knowledge of operating systems:Comfort working with Unix/Linux command line environments. Good communication skills:Able to work collaboratively with cross-functional teams and understand business requirements.
• Not to Exceed Rate : (No Value)