Job Description :
Database Administrator & Software Engineer
Location: Alpharetta, GA
Duties: Write complex SQL queries involving inner and outer join, store procedures, triggers and user defined functions, Perform Performance Tuning, Query Optimization, Manage Alerts, Operators and Jobs through SQL Server Agent, Create Dimensional Modeling and ETL design. Work on ETL process using SSIS packages, Create packages to extract data from DB2 (AS/400), ORACLE, MS ACCESS and FLAT FILES and load it to SQL SERVER use DTS/SSIS and implement Incremental load in SSIS packages, Deploy SSIS Packages using Team Foundation Server and migrate SSIS packages, Design STAR, SNOW FLAKE Schemas, Report writing using SQL Server Reporting Services (SSRS) and create various types of reports like Drill Down, Drill Through, Parameterized, Cascading, Table, Matrix, Chart, Adhoc and Sub Reports, Creating Data Visualizations using Tableau/Power BI, Work with Data Modeling Tools like Erwin and Microsoft Visio, Good understanding of (SDLC) Software Development Life Cycle process methodologies and principles
Requirements: Masters Degree in Science, Information Technology, Electronics or a related field and 2 years experience, or a Bachelors Degree in Science, Information Technology, Electronics or a related field and 5 years experience must include at least two years in T-SQL, SSIS, SSRS, SSAS, Power BI, Tableau
SALARY: $77,501 per year
Job Description for Software Engineer
Duties: Analyze, design and develop solutions for complex applications problems, using Microsoft .NET C#,ASP.NET,EntityFramework, JSON, XML, MVC Architecture, WEB API, Rest and SOAP services, Application Servers (IIS) , LINQ, Do application programming in MS SQL Server databases. Perform software application development as well as participate in all aspects of the Agile and SDLC lifecycle. Perform deployment configuration, performance tuning, SLA management and integration with enterprise systems. Work in a high volume and high availability environment. Conduct requirement analysis, systems design, coding, testing, implementing software applications using a variety of technologies. Work in Delivery and On-boarding solution design and development; Create and Maintain all technical artifacts. Coordinate with users to determine requirements and provided technical guidance to onshore development teams. Provide QA, UAT and production technical support. Interact with end-users and business analysts to identify and develop business requirements and transform it into Technical requirements and deliver the solution. Will be Responsible for Build and Release of API in Development and Production environment
Microsoft .NET C#, ASP.NET,WCF,Web Forms, Entity Framework, JSON, XML,HTML, MVC Architecture, WEB API, Rest and SOAP services, Application Servers (IIS), LINQ, MS SQL Serve
Requirements: Bachelors Degree in Computer Science and Engineering, Information Technology, Electronics or a related field and 2 years experience, or a Bachelors Degree in Science, Information Technology or equivalent and 4 years of experience.
SALARY: $104,790.00 per year
Travel required: Up to 50%
HOURS: 9:00 A.M. - 5:30 P.M 40 hours per week
POSITION LOCATION: Competent Systems Inc. 4080 McGinnis Ferry Rd Suite# 1504 Alpharetta GA 30005 USA.
May require travel to various unanticipated client sites nationally.
CONTACT: Human Resources Manager, Competent Systems Inc. (Attn McGinnis Ferry Rd Suite# 1504, Alpharetta GA 30005 USA. Email with “Attn:191001” at the subject line.