Data Platform Admin

Role Description:             1 · Understand customer Application modelling needs and design metamodels and transformation of data to target database formats with strong understanding of CIM 2· Works with customers on model migration and conversion of data to format needed for advanced Power Systems Applicatio. 3· Implement EMS, ADMS and SCADA systems. · Contribute and lead advanced Power Systems Application software development and delivery to meet project/product commitments. 4· Engage with customers which mainly consist of Electric Utilities for Transmission and Distribution System Operators. Competencies:  PL/SQL Experience (Years):         6-8 Essential Skills:  Oracle DBA1. Functional and Technical Knowled of Utility GRID Applications like SCADA, OMS, DMS, EMS, DERM experience Required 2· Knowledge and experience with electric utility industry practices 3· Functional understanding utility GRID applications like Outage Management, Distribution Management or Energy Management applications for Power Utilities. 4· Exposure to CIM and other model exchange formats. 5· Understanding and Handson experience of Electrical Data Modelling. 6· Experience of implementing application configuration for SCADA, OMS, DMS and EMS software configurations. 7· Proven software design and development skills. 8· Database skills SQL/PLSQL. 9· Principles of SDLC and methodologies like Lean/Agile/XP, CI, software and product security, scalability, documentation practices, refactoring, and testing techniques.1· Work on defining functional software specifications, designing, coding, testing, integration, delivery, and maintenance. 2· Provide domain knowledge and/or technical leadership to a team of electric power application software engineers. 3· Lead and contribute to electric power application development and ensure software delivery is on schedule and per customer expectations. Desirable Skills: Oracle DBA1. Functional and Technical Knowled of Utility GRID Applications like SCADA, OMS, DMS, EMS, DERM experience Required 2· Knowledge and experience with electric utility industry practices 3· Functional understanding utility GRID applications like Outage Management, Distribution Management or Energy Management applications for Power Utilities. 4· Exposure to CIM and other model exchange formats. 5· Understanding and Handson experience of Electrical Data Modelling. 6· Experience of implementing application configuration for SCADA, OMS, DMS and EMS software configurations. 7· Proven software design and development skills. 8· Database skills SQL/PLSQL. 9· Principles of SDLC and methodologies like Lean/Agile/XP, CI, software and product security, scalability, documentation practices, refactoring, and testing techniques.1· Work on defining functional software specifications, designing, coding, testing, integration, delivery, and maintenance. 2· Provide domain knowledge and/or technical leadership to a team of electric power application software engineers. 3· Lead and contribute to electric power application development and ensure software delivery is on schedule and per customer expectations.

Fully onsite, temp to perm, ASAP start date. Pay is BOE 48-85 per hour • 30% Network Operations and Security Management: Responsible for the daily operations, maintenance, and troubleshooting of the branch’s network. Monitor and analyze network performance, respond promptly to and resolve operational issues and incidents. Perform fault diagnosis and resolution for various types of network failures; create and manage support tickets with third-party vendors for any type of network performance degradation or system issue. Conduct regular and ad-hoc health checks to identify and eliminate risks, ensuring the overall health of the network environment. Coordinate with maintenance vendors for hardware repair and replacement. Responsible for network-related disaster recovery activities, including drills, testing, and documentation. • 25% Network Architecture Optimization and Technical Standards Development: Design and optimize network architecture by incorporating industry best practices and aligning with headquarters’ technical standards. Continuously improve the network architecture and evaluate emerging technologies for potential adoption. Revise and refine network management technical standards in accordance with HQ requirements and local business needs. • 20% Network Asset Management: Maintain and update network topology diagrams, as well as asset records for network devices and leased lines. Manage VLANs, IP addresses, DNS, and domain environments. Responsible for network configuration management and firewall port administration. Implement lifecycle management for network devices, including procurement and replacement. Handle equipment installation, placement, cabling, labeling, power supply, stacking, and routine inspections. • 10% Network Version and Patch Management: Responsible for the installation, configuration, patching, and maintenance of network infrastructure supporting the headquarters and branch data centers. Coordinate planned network upgrades with HQ departments and third parties. Perform firmware updates for network and security devices to ensure they remain on the latest versions. • 5% Network Business and Financial Management: Liaise with network vendors and participate in budgeting, procurement, contracting, invoice review, and payment processes for network-related services, ensuring service quality, cost control, and compliance. Collaborate with the Information Security Office and Risk Management Department to oversee vendor management and monitor their adherence to service level agreements (SLAs). • 5% Collaboration and Support: Work closely with other technical teams to complete network-related tasks. Provide network support and guidance to other IT staff, promoting knowledge sharing and continuous improvement. • 5% Other Duties: Perform additional related responsibilities as assigned. Requirements • College graduate with specialization in Computer Science, Information Technology, Computer Engineering or a related discipline or equivalent experience or equivalent combination of education and experience. • 3 years of satisfactory, progressive experience in network administration in a business environment incorporating switch, router and firewall configuration, network monitoring, and experience utilizing network management tools to that are acceptable to the management of the Information technology Department. Knowledge of network topology, understanding of LANS, VPN, Wi-Fi, etc. is required. • Fluent in English and Chinese. SPECIFICATIONS: • Strong knowledge in network administration, cyber security, IT operation, inventory and patch management, incident response, and etc.; • Must be able to prioritize work and multitask in a fast-paced environment. • Require participation in periodic network devices updates outside of normal business hours and respond to network-related operation issues and incidents in a timely manner. • Communication regarding work matters with the headquarters is allowed outside of regular working hours. • Have strong written and oral communication skills in English and oral communication in Mandarin. Self-motivated and with strong responsibility. • Holding professional certifications of CCNA, CCNP or CISSP is a good plus.

The ideal candidate will be responsible for the installation, configuration, maintenance, and performance tuning of our databases, ensuring their availability, reliability, and security. Key Responsibilities: ·                  Install, configure, and maintain Oracle and PostgreSQL databases. ·                  Perform database backups, restores, and disaster recovery operations. ·                  Monitor database performance and optimize queries and indexes for improved performance. ·                  Analyze and resolve performance issues through query optimization, indexing, and tuning. ·                  Implement and monitor database performance metrics and alerts. ·                  Conduct regular database health checks and performance reviews. ·                  Ensure database security through user management, access control, and encryption. ·                  Implement and enforce database security policies and compliance requirements. ·                  Monitor and audit database activities to detect and respond to security threats. ·                  Apply patches, updates, and upgrades to databases and related systems. ·                  Manage database migrations and version upgrades with minimal downtime. ·                  Develop and maintain documentation for database configurations, procedures, and policies. ·                  Provide technical support and troubleshooting for database-related issues. ·                  Collaborate with development and operations teams to resolve database-related problems. ·                  Participate in on-call rotation and respond to critical incidents as needed. ·                  Design and implement robust backup and recovery strategies for databases. ·                  Test and validate backup and recovery procedures to ensure data integrity and availability. ·                  Monitor backup processes and address any issues related to backup failures. Qualifications and Preferred Skills: ·                  Bachelor’s degree in computer science, Information Technology, or a related field. ·                  Proven experience as a Database Administrator with expertise in Oracle and PostgreSQL. ·                  Strong knowledge of database design, data modeling, and SQL. ·                  Experience with database performance tuning, backup and recovery, and security practices. ·                  Familiarity with scripting languages (e.g., Python, Shell) for automation tasks. ·                  Excellent problem-solving skills and attention to detail. ·                  Strong communication and collaboration abilities. ·                  Certifications in Oracle Database Administration (e.g., OCA, OCP) and PostgreSQL. ·                  Experience with additional database technologies or cloud databases (e.g., AWS RDS, Azure SQL). ·                  Knowledge of database high availability solutions and clustering.

Booklog is looking for a level 1 – 3 technical support individual. This position is to provide outstanding technical support for Booklog software and various interfaces along with onboarding of new customers, testing of software and training on usage of software. We’re looking for a motivated individual to be part of our committed team. We need to be the experts so our customers don’t have to. Located in Chicago’s Andersonville neighborhood; telecommuting is available. Qualifications • At least 2 years experience in technical support, preferably phone support • Experience with Microsoft Windows operating systems • Familiarity with databases and database troubleshooting • Knowledge of computer network systems • Ability to troubleshoot software problems and offer solutions by phone • Good problem solving skills with attention to detail • Strong verbal, written, interpersonal, and organizational skills • Ability to work both independently and in a team environment • Experience with SQL Server 2022, Sybase SQL applications and databases • Ability and excitement to learn new skills • A ‘think outside of the box’ mentality • Customer Service experience • Software training experience a plus • Previous experience training customers on software usage • Experience with use of peripheral devices • 10% or less travel to customer locations within the US to train and install software Benefits • Casual environment with a great group of people who love what they do • In office or telecommuting options • 100% paid health insurance • 2 weeks vacation to start • Generous 401K options • Permanent full-time. PLEASE SEND RESUME WHEN APPLYING

" Key Skills Required Performance Tuning Lead with SQL, Databricks, Azure Cloud. Experience tuning queries for both master data hubs and transactional data hubs on cloud infrastructure. Strong troubleshooting and root cause analysis skills. Ability to work independently under pressure to support a Tier 1 platform. Experience leading and mentoring junior engineers and developers on best practices for database and application performance. Primary Activities Data Platform Support for multiple data sources and destinations. Monitoring via tools like Datadog and Splunk. Testing of SQL queries for various applications consuming data from data hubs. L3 support - TechOps, 3rd party coordination. Maintaining production systems, deploying code in Production, resolving issues, and leading production troubleshooting calls. Production monitoring, creating monitoring dashboards, setting up alerts, triaging alerts. Working with Product Owners and other developers to implement scalable solutions. Qualification Bachelor’s degree in Information Technology, Computer Science, or a related field (or equivalent work experience). Previous experience in a managed services role or IT support (typically 5+ years). 5+ years of software and DevOps development engineering in a Linux environment. Experience with Azure Cloud, Azure DevOps, AKS. Experience building and operating high-performance mission critical systems. Experience using Datadog, Splunk, or other monitoring tools. Application Services Provide technical support for business-critical software applications, diagnosing and resolving user issues in a timely manner. Monitor application performance, resolve technical issues, and perform root cause analysis for recurring problems. Serve as the primary point of contact for application-related inquiries, working with users to address their needs. Release & Deployment Participate in the testing of new or updated applications, ensuring they meet functional requirements and quality standards. Assist with the release & deployment and rollout of new software versions or updates to users. Ensure smooth transition and minimal disruption during application changes, including user training and documentation. Perform enhancements as per requirements and ability to deploy. Reporting & Management Collect and analyze data from the applications to generate reports and provide insights to stakeholders. Monitor application usage and performance metrics to identify trends and potential issues. Provide recommendations for improving workflows or streamlining processes through better application use. Work with project managers and customers to ensure the applications meet evolving business requirements. Update application and architecture documentation as needed. Soft Skills Excellent problem-solving and troubleshooting skills. Strong communication skills, with the ability to explain complex technical concepts to non-technical users. Customer-oriented, with the ability to work both independently and as part of a team. Preferred Experience with IT service management frameworks preferred (e.g., ITIL). Knowledge of application performance monitoring tools. Experience with Kafka or another message broker. Experience creating and running Databricks notebooks. Experience developing Java based microservices. Experience developing Python scripts. Experience with MongoDB. Experience with PostgreSQL. Familiarity with Cassandra and/or Cosmos DB. Familiarity with Jenkins, Terraform, Ansible.

Booklog is looking for a level 1 – 3 technical support individual. This position is to provide outstanding technical support for Booklog software and various interfaces along with onboarding of new customers, testing of software and training on usage of software. We’re looking for a motivated individual to be part of our committed team. We need to be the experts so our customers don’t have to. Located in Chicago’s Andersonville neighborhood; telecommuting is available. Qualifications • At least 2 years experience in technical support, preferably phone support • Experience with Microsoft Windows operating systems • Familiarity with databases and database troubleshooting • Knowledge of computer network systems • Ability to troubleshoot software problems and offer solutions by phone • Good problem solving skills with attention to detail • Strong verbal, written, interpersonal, and organizational skills • Ability to work both independently and in a team environment • Experience with SQL Server 2022, Sybase SQL applications and databases • Ability and excitement to learn new skills • A ‘think outside of the box’ mentality • Customer Service experience • Software training experience a plus • Previous experience training customers on software usage • Experience with use of peripheral devices • 10% or less travel to customer locations within the US to train and install software Benefits • Casual environment with a great group of people who love what they do • In office or telecommuting options • 100% paid health insurance • 2 weeks vacation to start • Generous 401K options • Permanent full-time. PLEASE SEND RESUME WHEN APPLYING