What are the responsibilities and job description for the SYS ENG-SYS ANYS AND PROG - II position at Ampcus, Inc?
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.
Job Title: SYS ENG-SYS ANYS AND PROG - II
Location(s): Alpharetta, GA
Job Duties:
Job Title: SYS ENG-SYS ANYS AND PROG - II
Location(s): Alpharetta, GA
Job Duties:
- Translate user business requirements into program specifications.
- Create database objects Tables, Views, User defined functions, Store procedures, Joins, Dynamic SQL, Indexed Views, Daily Jobs and Workflow objects.
- Developed business logic workflows in SQL Server using stored procedures, UDFs, views, temp tables, variables, For loops, CTEs.
- Performance tuning on database Objects to achieve optimal data retrieval/updates using SQLProfiler, Execution plan.
- Execute SQL Task and Data Flow Tasks were used extensively as part of ETL packages.
- Monitoring daily database jobs, data loads and proactive resolution of issues to ensure maximum uptime/availability of database for reporting.
- Prepare Unit, Integration and System test plans and execute and log results.
- Analyze and fix bugs in the existing system.
- Create documentations and follow standards and methodology as defined by the project manager.
MUST HAVE SKILLS :
- SQL Server development in 2012, 2019 CTEs, Stored procedures, UDF, Database development SSIS package development, DB job debugging ETL
DESIRED SKILLS:
- Google Cloud Platform (GCP) C# Scripting.
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.
