SQL Developer Where Sheer Speed and Reason Meet Job Description Duties: Database Design: To guarantee data integrity, create and manage reliable database schemas, tables, and views using normalization principles. Stored Procedures & Triggers: Create and refine intricate stored procedures, functions, and triggers to automate data processing and business logic inside the database engine. Query optimization reduces CPU and I/O overhead by analyzing and fine-tuning slow-running queries utilizing Execution Plans, Indexing techniques, and Profiling tools. ETL Processes: Using programs like SSIS, Informatica, or Talend, create and implement Extract, Transform, Load (ETL) pipelines to move data between heterogeneous systems. DataSecurity: To safeguard sensitive data and guarantee GDPR/HIPAA compliance, put strong security measures in place, such as User Access Control, Data Encryption, and Masking. Backup & Recovery: To guarantee business continuity in the event of a system failure, create and test database backup, restoration, and disaster recovery plans.

Focus Skills: SQL Mastery: Proficiency with CTEs, Window Functions, and Dynamic SQL in T-SQL (SQL Server), PL/SQL (Oracle), or PG/SQL (PostgreSQL). Database modeling: The ability to create Entity-Relationship Diagrams (ERDs) using programs like ERWin, MySQL Workbench, or draw.io. Performance tuning requires a thorough understanding of statistics management, B-Tree indexes, and Columnstore indexes. Troubleshooting: The capacity to locate and fix blocking, fragmentation, and deadlocks in a production setting. Version Control: Knowledge of managing database scripts and migration files with Git or SVN.

Apply now to become an integral part of our growing team! With Regards, HR - Maria 88708 33430 infohrmaria04@gmail.com »