Who We Are
Artmac Soft is a technology consulting and service-oriented IT company dedicated to providing innovative technology solutions and services to the Customers.
Job Description
Job Title : Oracle PL/SQL and SQL Server(Queries, management, SSIS) Developer with Unix Shell Scripting
Job Type : C2C / W2 / 1099
Experience : 5 to 10 years
Location : Alpharetta, Georgia
Responsibilities
- 5+ years of experience in database development and management.
- Strong proficiency in Oracle PL/SQL and SQL Server.
- Experience with SQL Server Integration Services (SSIS) for ETL processes.
- Proficient in Unix shell scripting.
- Solid understanding of database design, indexing, and query optimization.
- Experience with database performance tuning and troubleshooting.
- Knowledge of data integration and data migration techniques.
- Excellent problem-solving skills and attention to detail.
- Strong communication and teamwork skills.
- Experience with other database technologies and tools.
- Familiarity with cloud-based database solutions (e.g., AWS, Azure).
- Knowledge of data warehousing concepts and practices.
- Certification in Oracle or SQL Server technologies.
- Design, develop, and maintain database systems using Oracle PL/SQL and SQL Server.
- Write complex SQL queries, stored procedures, and functions to support various applications.
- Manage and optimize SQL Server databases, including performance tuning and troubleshooting.
- Develop and maintain SSIS packages for data integration and ETL processes.
- Perform Unix shell scripting for automation of database tasks and maintenance.
- Collaborate with development teams to integrate database solutions with applications.
- Ensure data integrity and security across all database systems.
- Monitor database performance and implement improvements as needed.
- Provide support for database issues and troubleshoot problems promptly.
- Document database designs, configurations, and procedures.
Qualification
- Bachelor’s degree in Computer Science, Engineering, or a related field