Role Description At Ideaware, we’re building a cross-functional product team that will integrate quickly with our U.S.-based client — an international team operating in the Real Estate Technology space. We’re looking for a Junior–Mid Database Administrator (DBA) who can contribute from day one and support data integrity, performance, and analytics across the platform. You’ll join a fast-paced, product-driven environment where data reliability, efficiency, and accessibility are key to product success. This role is ideal for someone who enjoys working with data systems, optimizing performance, and enabling teams to make better, data-informed decisions. You’ll collaborate closely with engineering and product teams to support data-driven features and analytics workflows. Responsibilities - Optimize and maintain database performance through query tuning, indexing, and monitoring. - Design and support data models to ensure scalability, consistency, and efficiency. - Collaborate with engineering teams to support data-driven features and backend integrations. - Support and maintain data pipelines and analytics workflows. - Ensure data integrity, accuracy, and availability across systems. - Assist in building and maintaining reporting structures and datasets. - Identify opportunities to improve data architecture and performance. - Explore and adopt tools (including AI-driven tools) that improve data workflows and productivity. Qualifications - 2+ years of experience working with SQL, including query optimization, indexing, and performance tuning. - Experience with data modeling and reporting. - Ability to support data pipelines and analytics workflows. - Comfort working with engineering teams on data-driven features. - English proficiency at B2 level or higher (able to communicate effectively in written and spoken form in professional settings). Nice to Have - Exposure to cloud data environments (Azure or similar). - Experience supporting AI/ML data pipelines or working with structured datasets for LLM usage. Benefits - Fully remote — work from anywhere. - Benefits — PTO and other perks depending on the client. - Work with US-based companies building exciting, impactful products. - Join collaborative, high-performance teams that value your input and expertise.

Role Description We are seeking a Senior Informatica Administrator to support a high-impact data initiative focused on delivering a mobile-first Salesforce recruiting solution. This role will be instrumental in standing up a new Informatica environment and enabling data migration efforts from legacy systems into Salesforce. The ideal candidate will bring deep expertise in Informatica ETL and administration, along with the ability to mentor team members and establish best practices for ongoing data operations. - Lead the setup, configuration, and administration of a new Informatica environment - Design and implement ETL workflows to support data migration and integration efforts - Migrate Soldier data from legacy systems (Mainframe/Oracle-based ARISS system) into Salesforce - Work with JSON-based data inputs from source systems to transform and load into target platforms - Collaborate with the data team to support a mobile-first Salesforce recruiting solution - Provide hands-on training and mentorship to 2–3 team members on Informatica configuration and best practices - Ensure data integrity, quality, and performance optimization across all ETL processes - Troubleshoot and resolve data integration and system issues Qualifications - Active Secret Clearance - Informatica Administration – Intermediate proficiency - Informatica Data Engineering – Intermediate proficiency - Informatica ETL Development – Advanced proficiency - Experience integrating Informatica with Salesforce.com – Intermediate proficiency - Strong experience working with structured and semi-structured data formats (e.g., JSON) - Proven ability to configure and deploy new Informatica environments Requirements - Experience with data migration projects in cloud environments - Familiarity with AWS infrastructure - Working knowledge of Salesforce platform and data models - Experience migrating data from legacy systems (Mainframe, Oracle) Benefits - Strong problem-solving and analytical skills - Ability to work independently in a remote environment - Excellent communication skills with the ability to train and mentor team members - Experience working in secure, compliance-driven environments

Name of position: Sr Oracle Database Administrator Position is remote, but candidates should reside within driving distance of Harrisburg office to report on-site if/when needed Position Overview We are seeking an experienced Oracle Database Administrator (DBA) to manage and maintain our mission-critical Oracle 19c environment running on Red Hat Enterprise Linux (RHEL). The ideal candidate will have deep expertise in Oracle RAC and ASM, and the ability to work independently on routine maintenance as well as specialized tasks. Key Responsibilities - Perform routine and advanced database administration tasks for Oracle 19c RAC and ASM environments. - Implement and maintain database backup and recovery procedures, ensuring data integrity and security. - Manage access security, database integrity, and physical data storage design. - Oversee data storage management and supervise performance tuning activities. - Author shell scripts for backup, restore, and monitoring tasks. - Monitor database performance, space requirements, and optimize system resources. - Identify and track issues, risks, and action items; provide accurate and timely status updates. - Assist in coordinating software releases and upgrades. - Ensure compliance with quality standards and best practices. - Work collaboratively in a team environment while being capable of independent execution of tasks. Required Technical Skills - Oracle RAC and ASM administration expertise. - Strong knowledge of Oracle 19c architecture and features , including Pluggable Databases (PDBs). - Proficiency in Linux (RHEL) shell scripting. - RMAN (Recovery Manager) for backup and restore operations. - Performance tuning at both database and SQL query level. - SQL and PL/SQL scripting for automation and troubleshooting. - Patch management and applying PSU/CPU updates. - Familiarity with OEM, AWR, ADDM, and ASH reports for monitoring and diagnostics. - Security hardening and compliance (encryption, auditing). - Capacity planning and forecasting for database growth. Preferred Skills - Experience with Oracle Data Guard for disaster recovery and high availability. - Experience with UDEV configuration for ASM devices. - Exposure to cloud-based Oracle deployments. - Knowledge of automation tools for database operations Soft Skills - Strong analytical and problem-solving skills for diagnosing complex issues. - Excellent documentation skills for procedures and standards. - Effective communication skills for reporting and collaboration. - Ability to manage time and priorities in a fast-paced environment. If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit. About Us: Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specialises in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.

Role Description We are seeking an experienced and highly skilled Senior Site Reliability Engineer with infrastructure-focused skills including: - Scaling - Availability - Performance - Backup/recovery - Cost optimization Additional database expertise is required to manage our MySQL, Amazon Redshift, and Snowflake database platforms. In this role, you will be responsible for: - Maintenance, administration, upgrades, and migration of databases to support high-performance, scalable, and secure data solutions. - Collaborating with cross-functional teams to ensure database systems meet organizational needs and maintain optimal performance and reliability. Key Responsibilities - Database Design and Architecture: - Develop and enforce database standards, best practices, and security protocols. - Migrate databases across accounts/regions prioritizing availability and latency. - Performance Tuning and Optimization: - Monitor and analyze database performance, identifying bottlenecks and implementing solutions to improve efficiency. - Assist with database caching, indexing, and resource allocation. - Access, Maintenance and Operations: - Administer and optimize environments including user access, roles, and cost controls. - Implement and manage backup and recovery strategies wherever needed and applicable. - Ensure database systems are highly available and resilient, including configuring replication and clustering as needed. - Perform routine maintenance tasks such as patching, upgrades, and storage management. - Automate database operations using scripts and tools. - Monitoring: - Implement monitoring solutions to proactively detect and resolve database issues. - Ensure compliance with data security policies and regulatory requirements. - Track cost/usage by team. - Collaboration and Leadership: - Provide guidance and mentorship to junior team members. - Collaborate with software developers, data engineers, and analysts to align database solutions with business needs. - Participate in capacity planning, budgeting, and strategic decision-making for database technologies. - Snowflake specific responsibilities: - Collaborate with data engineers and analytics teams to assist with ELT/ETL pipelines. - Migrate the data from a Redshift cluster to Snowflake. - Monitor usage and implement cost governance policies for Snowflake workloads. Qualifications - Education: Bachelor's degree in Computer Science, Information Technology, or related field. Equivalent experience will also be considered. - Experience: Minimum 7+ years of experience managing databases, with at least 3 years specializing in MySQL, Snowflake, and Redshift Spectrum. - Skills and Knowledge: - Proficiency in database administration, including replication, clustering, and high availability. - Demonstrated experience running complex database migrations that may have included multiple teams, across accounts, and/or across regions. - Expertise in MySQL, Snowflake, Amazon Redshift, and Redshift Spectrum, including data lake integration. - Understanding of SQL and database internals, including storage engines and query execution plans. - Experience with data pipeline tools (e.g., Apache Airflow, AWS Glue). - Knowledge of monitoring tools (e.g., CloudWatch, Prometheus) and scripting languages (e.g., Python, Bash). - Familiarity with cloud infrastructure, particularly AWS (S3, Lambda, IAM, etc.). Preferred Qualifications - AWS certifications (e.g., AWS Certified Solutions Architect, AWS Certified Database Specialty). - Experience with big data technologies such as Hadoop, Hive, or Spark. - Familiarity with DevOps practices, including both infrastructure as code (Terraform) and CI/CD pipelines for database deployments and managing users. - Familiarity with Clickhouse database. Soft Skills - Excellent problem-solving and analytical skills. - Strong communication and collaboration abilities. - Ability to work in a fast-paced, dynamic environment and manage multiple priorities. Benefits - Target cash compensation range: $136,100.00 - $174,210.00 USD Annually. - Competitive, market-informed compensation. - Participation in iSpot’s equity plan to receive stock options. - Eligibility for (pre-approved) overtime pay for non-exempt roles. Hybrid & Flexible Workplace Policy iSpot supports a hybrid and flexible workplace. Depending on location and work responsibilities, employees may be designated as full-time or part-time office-based or a fully remote employee. A hybrid work schedule indicates that you work in the office some days and work from home other days. Those local or living in surrounding areas to one of our offices (Bellevue, WA or New York, NY) will work a hybrid schedule, coming into their local office 1-3 days a week. While those in a role not office-based and located further away from our offices will work a fully remote schedule. If you have questions regarding exact details of our hybrid & flexible workplace policy, please let your recruiter know and they will discuss with you further.