An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
Posted over 15 days ago, so the role may have closed. Confirm on the employer's page when you apply, or see similar jobs.
Job Description
- You should have 8-10+ years of experience in MySQL, SQL, and ORACLE. Your responsibilities will include designing and implementing databases and data modeling, creating indexes, views, complex triggers, stored procedures, functions, and store procedures for efficient data manipulation and consistency. You will be designing databases, writing sequences, jobs, complex queries in SQL, MySQL, and ORACLE. It is essential to have a strong understanding of Keys, Constraints, Indexes, Joins, CTEs, Partitioning, Row Number() and Windows function, Temporary Tables, UDTs, Types of Union, Materialized views, etc.
Your role will involve troubleshooting, optimizing, and tuning SQL processes and complex queries, writing unit test cases, and understanding database transactions and states. You will also design, implement, and monitor queries and stored procedures for performance, debug programs, and integrate applications with third-party web services. Identifying opportunities for improved performance in SQL operations and implementations is crucial.
You should have knowledge of database Backup, Restore & Maintenance, as well as working in development, testing, UAT, and production environments and their databases. Experience in SSRS and SSIS is required, and experience in SSAS will be a plus. Good communication skills are essential for this role.
Key Skills: Performance tuning, database transactions, SSRS, SQL query optimization, ORACLE, de-normalization, triggers, backup and restore, SSAS, views, database, indexes, functions, stored procedures, database design, data modeling, unit testing, MySQL, database normalization, SSIS, SQL,
Skills
SsasViewsSsisSqlPerformance TuningDatabase TransactionsSsrsIndexesUnit TestingDenormalizationSql Query OptimizationRestoreMysqlOracleStored ProceduresBackupFunctionsData ModelingDatabase DesignDatabase NormalizationTriggersDatabaseIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
Similar Jobs
View all
New IT / Software Development & Related roles in Maharashtra.
One email a day. Unsubscribe any time.
