ABCS, Inc.

Title: Database Administrator Duration: 4 months Contract to Hire Location: Hybrid- Phoenix, AZ (Local Arizona candidates only) Pay Rate: Upto $50/hr on W2 OR $55/hr on 1099 (All inclusive / no benefits) Job Description: Required Skills Either PowerShell scripting or Power BI experience (need to have one or the other) Disaster recovery SQL Server Management of Azure database virtual machines Implement version control and DevOps practices for database objects Logical and physical database design Preferred Skills Designing and writing stored procedures Design and implement ETL processes for data integration and transformation Develop and optimize complex SQL queries and stored procedures Implement indexing strategies for performance improvement This is a 4 month contract to hire position. All candidates must be eligible to convert to an FTE. The client is unable to sponsor any visas. In office 2-3 days onsite first week then once a month or as needed. Job Summary: Responsible for assisting with the management of all aspects of the client's data including but not limited to: Database backup and recovery Logical and physical database design Designing and writing stored procedures Disaster recovery Database maintenance, connectivity, replication, performance and tuning, upgrades, naming conventions and standards Installation and configuration of database software (SQL Server) Diagnosing and correcting database operational problems Strong PowerShell scripting skills for jobs automation Configure and support Power BI datasets, gateways, and refresh schedules Design and develop stored procedures, functions, and triggers Develop and optimize complex SQL queries and stored procedures for reporting and analytics Design and implement ETL processes for data integration and transformation Collaborate with application and BI teams to support data-driven solutions Implement version control and DevOps practices for database objects Occasional in-state travel is required for this position Job Duties: Assist and cross-train in the work of other database administrators Review and recommend improvements to existing architecture Tune performance, review, and recommend improvements to existing code Meet with other IT staff to determine scope of system requirements related to data storage, retrieval, and performance Design and code stored procedures and scripts to facilitate database administration (Powershell experience desired) Develop database administration tools/utilities/operation procedures Assist in developing purge/archive criteria and procedures for historical application data Proactively solve complex problems Review, evaluate, design, implement and maintain company database s Implement and review appropriate security guidelines/mechanisms Implement database migrations and changes Management of Azure database virtual machines Troubleshoot application key selection, creation of appropriate indexes, and query needs Ensure that databases are operational and functioning properly Perform database maintenance functions Move, rebuild, or change database objects as required in production Develop and test database migration procedures Manager Power BI Configuration Assist in interviewing and training new hires and provide guidance to Junior Developers when required Manage SQL Server Always On configurations Provide on-call support to correct database issues or assist with other processes that require off-hours support Educate users and maintains database documentation Establish database procedures and standards; assists in database design Writing PowerShell scripting Design, develop, and optimize stored procedures, functions, and queries Implement indexing strategies for performance improvement Build and maintain SSIS packages for ETL workflows Other duties as assigned as related to the position Knowledge, Skills & Abilities (KSAs): General working knowledge of physical data models, technical architecture, system interfaces, etc. Database Software: SQL Server 2000 - SQL Server 2022 Hardware installation and configuration (Azure) SQL Server Clustering Transact-SQL and stored procedure design Database performance tuning and replication Disaster recovery planning Backup/recovery planning SQL Server Always On groups Power BI Configuration Powershell scripting A Bachelor's degree plus five or more years of experience in database administration, or equivalent experience to substitute for the degree, is required. Skills in: Strong customer service skills Excellent interpersonal, written and oral communication skills Analysis and problem solving for complex information and data collection systems Intermediate to advanced skill in using Microsoft Outlook, Word, and Excel Demonstrated ability to: Balance, prioritize and organize multiple tasks Work collaboratively in teams and across organizations Synthesize feedback and adjust plans accordingly Build strong relationships inside and outside the organization Develop and write technical documentation Model and design relational databases Install and support relational database management systems (RDMS) Evaluate and test emerging technologies Apply creative solutions to business problems to ensure business needs are most effectively Develop PowerShell scripts for automation and administrative tasks Configure and support Power BI datasets, gateways, and refresh schedules

Title: Sr Salesforce Developer / Architect Duration: 9-12 month contract Location: Hybrid- Phoenix, AZ (Local Arizona candidates only) Pay Rate: Upto $63/hr on W2 OR $69/hr on C2C (All inclusive / no benefits) Job Description: Required Skills A minimum of five (5) years of experience as lead developer on one or more Salesforce implementations. Bachelor's degree in Computer or related field Salesforce, MuleSoft, Microsoft SQL, Oracle experience The Application Developer's primary responsibilities will be to focus on ensuring the development of quality software using best practices architecture, coding practice and development processes on a day-to-day basis. This position will work with Business Analyst and functional users to determine functional requirements and provides customization, maintenance and updates as needed. Additionally, will also participate with cross-functional teams to establish and support the application development and test environments to meet client's requirements. As a Salesforce developer, will identify, design, and deploy technology and process solutions establishing key business capabilities and operational improvements for the client. A hybrid work schedule (some work in the office and some work from home) is available for this position. The person in this position will be responsible for: Creating, designing, implementing, and maintaining applications associated with the client's mission on multiple platforms including but not limited to: Salesforce, MuleSoft, Microsoft SQL, Oracle. Performs deep dive analysis, and reverse engineering of existing code banks to apply fixes and develop changes to applications on the platforms mentioned above. Participating in project teams involved in the planning, design, development, and implementation of new applications. Ensuring existing interfaces and programs comply with changes in technology directives and/or Department statues, regulations, and rules, writing technical documentation on application specifications and maintaining effective working relationships to improve the systems of the agency, developing and applying business knowledge in one or more functional areas. Experience with: Collaborated with business stakeholders to design and implement agency-critical solutions on the Salesforce Platform using Agile methodologies and source control to ensure best practices and versioning integrity. Ability to assess existing system and refactor and redesign in order to make a more optimal solution. Knowledge of: Proficiency in the development of Salesforce Public Sector Solutions applications and Application Programming Interfaces (API). Deep understanding of OmniStudio Solution Design and Development - OmniScripts, Data Mappers, Integration Procedures, Document Generation Advanced knowledge in the development of MuleSoft integrations. Relational database, such as Oracle, SQL Server Skill in: Establish and maintain effective working relationships within the Department, other governmental entities, private and public sectors, such as salesforce. Salesforce development, configuration and administration. Effective written and verbal communication. Detail-oriented approach to complex analysis and customer-centric problem resolution. Strong Customer service skills. Ability to: Design, code, and test applications based on user requirements and emerging technologies. Balance and organize multiple tasks to meet project deadlines. Translate complex technical and regulatory information into concise documentation and presentations for diverse audiences. Work effectively with internal teams and external stakeholders at all organizational levels. Synthesize feedback and adjust plans accordingly. Bachelor's degree in Computer Science or similar field. A minimum of five (5) years of experience as lead developer on one or more Salesforce implementations.