PostgreSQL / SQL Developer

*PostgreSQL / SQL Developer* Required Skills/Experience A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or three (3) years of equivalent experience in a related field. *Preferred Experience* At least five (5) years of experience with *Microsoft SQL Server Database Administration* At least five (5) years of experience with *Microsoft SQL programming*including troubleshooting and *investigating complex database issues* At least one (1) year of experience with Microsoft SQL Server High Availability Experience with any other database technology like *PostgreSQL *would be a plus. *Active MBI experience* is preferred. *Location:* Remote, USA *Experience:* Junior, Mid, Senior and Lead Level *Status:* Full time position with full company benefits *Principal Responsibilities* · Ensure servers are current with SQL Server patches and security updates. · Analyze and evaluate the security procedures required for specific mission-critical business systems as defined by customer security standards. · Perform all database security checks and manage all database securities. · Create and implement plans for system security using a variety of technologies to provide data security and auditing functions for customer’s mission critical systems. · Maintain security and integrity of data access policies, standards, and methods by establishing database recovery plans to minimize data losses and system downtime. Develop backup routines for both the database management system software and the stored data. · Develop standardized application security procedures for customer applications and databases. · Create, maintain, and monitor Always On Availability Groups (AAG) for High Availability. · Maintain SQL Server test environment where upgrades and security patches can be tested. · Perform integration testing, create and restore server imaging, develop and implement plans to roll over customer’s enterprise-wide systems from testing to production. · Install and upgrade SQL Server and other related software on customer’s specified hardware to provide functional capabilities for critical systems. · Create software and database maintenance plans for efficient upgrades and maintenance. Implement the plan and update this regularly. · Provide hardware and software specifications for various systems. · Coordinate database management system interfaces with other data processing units. · Review and approve or reject database designs for new systems. · Configure backup jobs to run on specified schedules. · Restore data files or tables from a previous backup session. · Develop and maintain scripts and perform and monitor backups for mission critical servers. · Work with vendors, developers, users, project managers and back up operators to troubleshoot database connectivity and back up issues. · Prepare and implement disaster recovery plans for various SQL Server based software systems. · Create and properly plan upgrade and migration schedules to minimize impact on production and mission critical systems. · Research, lab test, document and make recommendations to the Manager on new database technologies that could be implemented. Provide recommendations about the migration and upgrade paths for various systems. · Coordinate the installation and implementation of database management system software and related software tools with vendors, data processing staff and system users. · Develop and implement new database management policies, procedures and standards. · Collect data dictionary information on existing Microsoft Access 2003 databases. · Consolidate data from multiple sources (including standalone Microsoft Access databases) onto a centralized Microsoft SQL Server. · Develop and create new database solutions based on business unit requirements. · Conduct random health checks on the databases and prepare performance reports. · Assist System Administrators on database issues/errors and assist users and programmers with SQL queries and tuning. · Perform routine maintenance tasks for proactive monitoring on the database servers such as deleting log files and dump files or correcting errors. · Create repeatable processes to upgrade, test, and maintain databases and software systems. Monitor the systems to provide a minimum level of performance as part of Quality Assurance (QA). · Monitor database performance and make modifications and adjustments to database architecture, storage methods and management system software to fine-tune the database for optimum response time. · Prepare statistical and narrative reports of database management performance, activities and special projects. · Troubleshoot problems related to availability of data to system users, space, database software, data flow, and data storage and data access. · Create, modify, and troubleshoot reports in Microsoft SQL Server Reporting Services. · Perform other duties as assigned. Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, marital status, political affiliation, disability, or genetic information, except where it relates to a bona fide occupational qualification or requirement. IBIS Systems creates an Affirmative Action Plan on an annual basis. Pursuant to federal law, the portions of IBIS Systems’ Affirmative Action Program that relate to Section 503 (Persons with Disabilities) and/or Section 4212 (Protected Veterans), are available for inspection upon request by applicants and employees during IBIS Systems’ normal business hours. NOTICE: EO/AA/VEVRAA/Disabled Employer – Federal Contractor. IBIS participates in E-Verify, a federal program that enables employers to verify the identity and employment eligibility of all persons hired to work in the United States by providing the Social Security number (SSN) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization. For more information on E-Verify, please contact IBIS on +1(312)451-5355 ,resumes@ibiinc.ai Job Type: Full-time Benefits: * 401(k) * 401(k) matching * Dental insurance * Health insurance * Life insurance * Paid time off * Parental leave * Tuition reimbursement * Vision insurance Compensation Package: * 1099 contract * Bonus opportunities * RSU * Stock options * Yearly pay Schedule: * 8 hour shift * Monday to Friday Experience: * Informatica: 3 years (Required) * SQL: 3 years (Required) * Data warehouse: 3 years (Required) Security clearance: * Confidential (Preferred) Work Location: Remote