Database Developer
Job Title: Database Developer – SQL Server / Oracle / Snowflake / Cloud
Employment Type: W2 / Full-Time
Location: United States (Onsite / Hybrid / Remote – Based on Client Requirement)
Visa: Open to all work-authorized candidates except H1BKey Responsibilities:
Design, develop, implement, and maintain database objects, schemas, tables, views, indexes, stored procedures, functions, triggers, and packages across SQL Server, Oracle, and Snowflake. Write, optimize, and troubleshoot complex SQL queries, T-SQL scripts, PL/SQL programs, joins, subqueries, CTEs, window functions, and analytical queries. Develop and maintain database logic, business rules, reusable procedures, functions, triggers, and transaction-processing solutions. Design and implement relational database schemas, logical and physical data models, normalization, relationships, constraints, indexing strategies, and partitioning. Perform database performance tuning using execution plans, query profiling, indexing, statistics, execution metrics, and workload optimization. Develop and maintain ETL/ELT pipelines using SSIS, Informatica, Azure Data Factory, AWS Glue, Snowflake, or other data integration tools. Design and support data warehouse solutions, including dimensional modeling, star schemas, snowflake schemas, fact tables, dimension tables, and data marts. Develop data migration, transformation, synchronization, reconciliation, and validation processes across on-premises databases and cloud platforms. Implement Snowflake solutions using virtual warehouses, stages, Snowpipe, Streams, Tasks, Time Travel, clustering, and secure data sharing. Implement database security, access controls, role-based permissions, encryption, auditing, data masking, and governance standards. Collaborate with Data Engineers, Data Architects, Application Developers, Business Analysts, QA Engineers, and business stakeholders to deliver reliable data solutions. Troubleshoot database incidents, resolve data integrity issues, document database designs, and support production releases and ongoing maintenance.
Contact: Mahesh Kyadari, Lead – Talent Management Team📧 maheshk@precisiontechcorp.com