Database administrator jobs in Stamford, CT - 36 jobs

Job Description Exceptional Service, Endless Improvement, Passionate People, and Honest and Forthright. Guided by our values, we foster a culture of growth, balance, and belonging where every team member can thrive. We are looking to bring on a Sr. Compliance Administrator who will be responsible for managing assessments to help develop, implement and maintain policies and procedures to ensure organizational compliance with regulatory frameworks. This role involves facilitating project tasks with clients, internal teams, and being a point of contact for external auditors to manage compliance activities, conduct assessments, and provide technical guidance. The Sr. Compliance Administrator works under the guidance of the Managed Compliance Supervisor and senior members of the Compliance Team. Responsibilities: Develop, review, and maintain security and compliance policies and SOPs to meet regulatory and framework requirements. Lead client assessments to identify policy, compliance, and risk gaps, and guide stakeholders through approvals and remediation. Configure and manage clients within the GRC platform, including compliance baselines, risk assessments, and task management. Oversee internal, third-party, and framework assessments (e.g., CCPA, CMMC, FINRA, HIPAA, NIST CSF 2.0, NYDFS, SOC 2), advising clients on remediation strategies and progress. Coordinate with external auditors and assessors, managing evidence collection, responses, and due diligence questionnaires. Manage compliance and security projects, ensuring timelines, milestones, and deliverables are met while clearly communicating status to clients. Design and facilitate annual tabletop exercises and track post-exercise action items. Build strong client relationships by providing compliance guidance, contributing to meeting agendas and roadmaps, and supporting policy approvals. Mentor junior team members, support team efficiency, and handle escalations as needed. Requirements Bachelor's degree or equivalent experience in IT, Compliance, or related fields. 5+ years of relevant auditing, compliance, or IT security experience. Current CISA, CIPP, CCP, or relevant compliance/security certifications are strongly preferred. Proven ability to communicate effectively with both technical teams and executive-level stakeholders. Experience working with GRC platforms, policy management tools, and audit preparation processes. Self-starter with strong organizational and multitasking skills. Valid US driver's license and ability to pass a background check Benefits Charles IT offers a comprehensive benefits package, including medical, dental, vision, life and disability insurance, paid holidays, PTO, 401(k), and performance-based bonuses. Team members also enjoy ongoing training, professional development, quarterly team-building events, and a collaborative workplace culture. Commitment to Inclusion: Charles IT is an equal opportunity employer committed to fostering an inclusive and respectful work environment. We welcome diverse backgrounds and perspectives and do not discriminate based on any protected characteristic.

Senior Code AdministratorRequired Qualifications (as evidenced by an attached resume):Bachelor's degree (foreign equivalent or higher). In lieu of a degree, four (4) years of directly related full-time experience or a combination of higher education and experience totaling four years may be considered. Seven (7) years of full-time experience in plan review and/or project administration. Current certification as New York State (NYS) Code Enforcement Officer. Must have, keep and maintain the appropriate valid NYS Driver's License; have a motor vehicle record which is free from major violations or a pattern of repeat violations. (***Out-of-State Applicants, see "Special Notes”). Preferred Qualifications:Master's degree (foreign equivalent or higher). Additional years of full-time experience in plan review and/or project administration. Two (2) years of experience in a supervisory role. Strong knowledge of and experience working with building codes, zoning regulations, and construction practices. Proficiency in using inspection and permitting software (ex. Upcodes). Brief Description of Duties:The Senior Code Administrator oversees the enforcement of building codes, zoning regulations, and other related ordinances to ensure the safety and compliance of construction projects. This role involves conducting inspections, reviewing plans, and providing guidance to developers, contractors, and the public. Excellent communication and interpersonal skills, strong problem-solving abilities, and the ability to work effectively with diverse stakeholders is crucial for this position. Code Enforcement: Ensure compliance with building codes, zoning laws, and safety regulations through inspections and plan reviews. Complete/review environmental impact assessments for campus projects for conformance with SEQRAInspections: Conduct thorough inspections of construction sites, buildings, and other structures to verify adherence to approved plans and codes. Assist developers, contractors, and the public with code-related inquiries, provide guidance on compliance issues, and address complaints or violations. Review all plans and specifications for State University Construction Fund (SUCF) and the Dormitory Authority for the State of New York (DASNY) administered projects. Review and approve construction plans, issue permits, and applications for compliance with relevant codes and regulations. Maintain accurate records of inspections, violations, and enforcement actions, and prepare reports as needed. Team Leadership: Lead and mentor the Code Compliance Manager, provide training and foster a collaborative team environment. Identify areas for process improvement, recommend and implement solutions to enhance code enforcement efficiency and effectiveness. Support the Campus Code Manager while partnering with code officials and fire marshals from the university Enterprise Risk Management division to support community development, safety and ensure coordinated enforcement efforts. Other duties or projects as assigned as appropriate to rank and departmental mission. Special Notes:This is a full-time appointment. FLSA Exempt position, not eligible for the overtime provisions of the FLSA. Minimum salary threshold must be met to maintain FLSA exemption. In addition to the employee's base salary, this position is eligible for $4,000 UUP annual location pay, paid biweekly. Essential Position: This has been designated as an essential position based on the duties of the job and the functions performed. Positions that are designated as such may be required to report to work/remain at work even if classes are canceled, and the campus is working on limited operations in an emergency. ***Out-of-State Applicants: Please note as a condition of employment and in order for this position to be tendered, the successful incumbent will be required to provide evidence of a valid license and driving abstract from the state issuing the license within five business days of a conditional offer and must obtain a NYS driver's license within 30 days of start date. For this position, we are unable to sponsor candidates for work visas. Resume/CV and cover letter should be included with the online application. Stony Brook University is committed to excellence in diversity and the creation of an inclusive learning and working environment. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, familial status, sexual orientation, gender identity or expression, age, disability, genetic information, veteran status and all other protected classes under federal or state laws. If you need a disability-related accommodation, please call the university Office of Equity and Access (OEA) at ************** or visit OEA. In accordance with the Title II Crime Awareness and Security Act a copy of our crime statistics can be viewed here. Visit our WHY WORK HERE page to learn about the total rewards we offer. The starting salary range (or hiring range) to be offered for this position is noted below, it represents SBU's good faith and reasonable estimate of the range of possible compensation at the time of posting. Job Number: 2500800Official Job Title: Associate Facilities Program CoordinatorJob Field: Administrative & Professional (non-Clinical) Primary Location: US-NY-Stony BrookDepartment/Hiring Area: Campus Planning, Design and ConstructionSchedule: Full-time Shift :Day Shift Shift Hours: 8:30 a. m. - 5:00 p. m. Posting Start Date: Dec 31, 2025Posting End Date: Jan 21, 2026, 4:59:00 AMSalary:$120,000 - $130,000Appointment Type: TermSalary Grade:SL4SBU Area:Stony Brook University

Senior Code AdministratorRequired Qualifications (as evidenced by an attached resume):Bachelor's degree (foreign equivalent or higher). In lieu of a degree, four (4) years of directly related full-time experience or a combination of higher education and experience totaling four years may be considered. Seven (7) years of full-time experience in plan review and/or project administration. Current certification as New York State (NYS) Code Enforcement Officer. Must have, keep and maintain the appropriate valid NYS Driver's License; have a motor vehicle record which is free from major violations or a pattern of repeat violations. (***Out-of-State Applicants, see "Special Notes”). Preferred Qualifications:Master's degree (foreign equivalent or higher). Additional years of full-time experience in plan review and/or project administration. Two (2) years of experience in a supervisory role. Strong knowledge of and experience working with building codes, zoning regulations, and construction practices. Proficiency in using inspection and permitting software (ex. Upcodes). Brief Description of Duties:The Senior Code Administrator oversees the enforcement of building codes, zoning regulations, and other related ordinances to ensure the safety and compliance of construction projects. This role involves conducting inspections, reviewing plans, and providing guidance to developers, contractors, and the public. Excellent communication and interpersonal skills, strong problem-solving abilities, and the ability to work effectively with diverse stakeholders is crucial for this position. Code Enforcement: Ensure compliance with building codes, zoning laws, and safety regulations through inspections and plan reviews. Complete/review environmental impact assessments for campus projects for conformance with SEQRAInspections: Conduct thorough inspections of construction sites, buildings, and other structures to verify adherence to approved plans and codes. Assist developers, contractors, and the public with code-related inquiries, provide guidance on compliance issues, and address complaints or violations. Review all plans and specifications for State University Construction Fund (SUCF) and the Dormitory Authority for the State of New York (DASNY) administered projects. Review and approve construction plans, issue permits, and applications for compliance with relevant codes and regulations. Maintain accurate records of inspections, violations, and enforcement actions, and prepare reports as needed. Team Leadership: Lead and mentor the Code Compliance Manager, provide training and foster a collaborative team environment. Identify areas for process improvement, recommend and implement solutions to enhance code enforcement efficiency and effectiveness. Support the Campus Code Manager while partnering with code officials and fire marshals from the university Enterprise Risk Management division to support community development, safety and ensure coordinated enforcement efforts. Other duties or projects as assigned as appropriate to rank and departmental mission. Special Notes:This is a full-time appointment. FLSA Exempt position, not eligible for the overtime provisions of the FLSA. Minimum salary threshold must be met to maintain FLSA exemption. In addition to the employee's base salary, this position is eligible for $4,000 UUP annual location pay, paid biweekly. Essential Position: This has been designated as an essential position based on the duties of the job and the functions performed. Positions that are designated as such may be required to report to work/remain at work even if classes are canceled, and the campus is working on limited operations in an emergency. ***Out-of-State Applicants: Please note as a condition of employment and in order for this position to be tendered, the successful incumbent will be required to provide evidence of a valid license and driving abstract from the state issuing the license within five business days of a conditional offer and must obtain a NYS driver's license within 30 days of start date. For this position, we are unable to sponsor candidates for work visas. Resume/CV and cover letter should be included with the online application. Stony Brook University is committed to excellence in diversity and the creation of an inclusive learning and working environment. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, familial status, sexual orientation, gender identity or expression, age, disability, genetic information, veteran status and all other protected classes under federal or state laws. If you need a disability-related accommodation, please call the university Office of Equity and Access (OEA) at ************** or visit OEA. In accordance with the Title II Crime Awareness and Security Act a copy of our crime statistics can be viewed here. Visit our WHY WORK HERE page to learn about the total rewards we offer. The starting salary range (or hiring range) to be offered for this position is noted below, it represents SBU's good faith and reasonable estimate of the range of possible compensation at the time of posting. Job Number: 2500800Official Job Title: Associate Facilities Program CoordinatorJob Field: Administrative & Professional (non-Clinical) Primary Location: US-NY-Stony BrookDepartment/Hiring Area: Campus Planning, Design and ConstructionSchedule: Full-time Shift :Day Shift Shift Hours: 8:30 a. m. - 5:00 p. m. Posting Start Date: Dec 31, 2025Posting End Date: Jan 21, 2026, 4:59:00 AMSalary:$120,000 - $130,000Appointment Type: TermSalary Grade:SL4SBU Area:Stony Brook University

Mindlance is a national recruiting company which partners with many of the leading employers in the Life Sciences, IT, and Financial Services sectors, feel free to check us out at ************************* Job Title: DBA Location: Englewood Cliffs, NJ DURATION:- 12+ Months Local candidate only on W2. Job Description • The lead DBA role requires hands-on production database administration skills, deep technical expertise MySQL including various third party versions like Percona Server. • The DBA will work closely with the development teams and operations team to manage, support and maintain more than 50 instances on MySQL Database across Digital platform. Required Technical & Leadership Skill Sets • BS degree or higher in Computer Science with a minimum of 5+ years hands-on database administration experience on MySQL Databases deployed on Linux servers • Sound understanding on installation, configuration, patching, supporting and upgrading MySQL servers including Percona servers • Strong understanding on MySQL backup and recovery strategies. • Familiar with MySQL Enterprise backup and recovery tools including 3rd party backup solutions like Percona xtrabackup • Strong understanding on MySQL replication including multi data-center replication for High Availability • Should be good with query tuning and Performance Optimization • Estimate database capacities, develop methods for monitoring and maintenance of database instances • Minimum 3+ yrs experience as Production Database Administrator • Should be good with MySQL Stored procedures and functions ? Good exposure to linux operating system • Should have 3+ years of experience on writing linux shell scripts , perl scripts etc Languages and Software Packages: • Languages : Linux shell scripting, perl, python • Database : MySQL, MySQL Cluster, Oracle, Redis • Tools : Percona toolkit, MySQL Utilities ? Development Methodologies: Agile development Responsibilities: Personal Skills: • Strong experience working with multi-site development teams. • Strong Communication skills (verbal and written) with an ability to work in a highly collaborative, multi-country/time zone environment. • Good organizational skills with the ability to track and prioritize numerous tasks. Proactive personality with a proven track record of following through and delivering on responsibilities. Highly adaptive and capable of being an individual contributor and working as part of an extended team. Additional Information Thanks & Regards, Shipra Chauhan | Team Recruitment | Mindlance Inc | ************.

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges. In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients - including governmental agencies and private companies - throughout the United States and India. We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career. Job Description Job Responsibilities: Provide technology consulting to external customers and internal project teams. Responsible for providing technical support and/or leadership in the creation and delivery of technology solutions designed to meet customers business needs and, consequently, for understanding customers businesses. As trusted advisor create and maintain effective customer relationships so as to insure customer satisfaction. Maintain knowledge of leading edge technologies and industry/market domain knowledge. Actively contribute to the solutions portfolio by providing information ranging from technical knowledge to methodologies based on experience gained from customer projects Acts as an expert providing direction and guidance to process improvements and establishing policies. Demonstrate strong knowledge in at least three major technology areas. Technical expertise is sought after and provided to several projects/accounts. Demonstrate in-depth knowledge of assigned technology and discipline area. Demonstrate in-depth knowledge of corporate organization and policies Required skills: Senior level 3PAR administrator expertise with recognized authority Identify and provide operations procedure inputs Daily administration Review commercially reasonable efforts consistent with the standards of practice existing within the information technology industry System stability Troubleshooting Storage integration Configuration End user coordination Server and network interdependencies Migration and transformation Identify and provide maintenance procedure inputs Data migration. Additional Information GOOD COMMUNICATION SKILLS DURATION: 6+ Months Contract INTERVIEW: Phone & Skype

VIP Automotive Group of Long Island is known for its exceptional leadership and customer-focused culture. Join our team for a professional work environment, continuous training, and the opportunity to be part of one of Long Island's most successful auto groups. At VIP, our purpose is to create exceptional value and experiences for every customer, surpassing our competitors. Our mission is to be the foremost provider of automotive sales and service, empowering our staff to deliver memorable customer experiences. Our team members enjoy a positive working environment with opportunities for professional growth through training and advancement from within the organization. Click Link below to learn more about our group and dealership - VIP Automotive Group Database Administrator (Full-Time) Salary: $35.00 - $50.00/hour (based on experience) Location: [Insert location or "On-site/Remote/Hybrid"] Schedule: Full-Time Are you a tech-savvy problem solver with a solid IT background? We are seeking a skilled and detail-oriented Database Administrator (DBA) to join our team and take ownership of our database systems. You will play a critical role in setting up and maintaining the structure, security, and integrity of our data environment. Key Responsibilities: Database Installation & Configuration: Set up and configure database systems for optimal performance and integration. Performance Monitoring & Tuning: Identify bottlenecks and implement improvements to ensure peak efficiency. Backup & Recovery: Establish and maintain robust backup strategies to ensure data preservation. Security Management: Control user access, enforce security protocols, and comply with data protection standards. Data Integrity & Availability: Guarantee consistent and accurate data through regular audits and error-checking. Capacity Planning: Anticipate storage needs and plan for future scalability. Troubleshooting & Support: Resolve database-related issues and provide ongoing technical support. Patching & Upgrades: Apply updates and patches to ensure systems are current and secure. Documentation: Maintain comprehensive and up-to-date documentation for all database systems and procedures. Team Collaboration: Partner with developers, IT teams, and stakeholders to deliver effective database solutions. ✅ Qualifications: Strong IT background with experience in database administration Proficiency in one or more database platforms (e.g., Oracle, SQL Server, MySQL, PostgreSQL) Knowledge of FTP, data security protocols, and system optimization Excellent problem-solving skills and attention to detail Ability to manage multiple priorities in a fast-paced environment Benefits Include: Medical and Dental Insurance 401(k) Retirement Plan Employee Discounts on Vehicle Purchases, Parts, and Service Paid Time Off Supplemental Benefit Plans (Short-Term Disability, Long-Term Disability, Supplemental Life Insurance) Comprehensive Employee Recognition Programs Opportunities for Career Advancement Professional Development Assistance Retirement Plan Schedule: Monday to Friday

Kforce has a client in Armonk, NY that is seeking a Senior Teradata Developer/DBA. Responsibilities: * Design and develop Teradata databases, tables, views, macros, and stored procedures * Write and optimize complex SQL queries for ETL processes and reporting * Implement data integration solutions using Teradata utilities (BTEQ, FastLoad, MultiLoad, TPump, FastExport) * Collaborate with data analysts and business teams to translate requirements into technical solutions * Perform unit testing and troubleshoot data issues within Teradata systems * Support migration and conversion projects (e.g., Oracle/Informatica to Teradata or Big Data environments) DBA Duties: * Install, configure, and maintain Teradata database systems * Monitor system performance and perform tuning for optimal efficiency * Manage user access, roles, and security policies * Implement backup, restore, and disaster recovery strategies * Conduct capacity planning and manage space allocation (Permanent, Spool, Temporary) * Maintain database integrity and ensure compliance with data governance standards * Provide on-call support for urgent incidents and performance issues* Bachelor's degree in Computer Science, Information Technology, or related field * Teradata certification is a plus * 3-5+ years of experience in Teradata development and administration * Proficiency in Teradata SQL and database architecture * Strong knowledge of ETL processes and data warehousing concepts * Hands-on experience with Teradata utilities (BTEQ, FastLoad, MultiLoad, TPump) * Experience with performance tuning and query optimization * Familiarity with scripting languages (Unix Shell, Python) * Understanding of data modeling (logical and physical) * Analytical thinking, problem-solving, communication, and ability to work in Agile environments Preferred Skills: * Exposure to Big Data technologies (Hadoop, Spark) * Experience with scheduling tools (Control-M, Autosys) * Knowledge of data governance and security best practices * Familiarity with BI tools (Tableau, Power BI)

EmTacq specializes in EM ployer T alent ACQ uisitions, matching the most qualified candidates with the most competitive positions available. We pride ourselves on not just putting bodies in seats, rather matching professionals to their careers. We are headquartered in the Raleigh / Durham, NC area. However, as a recruiting agency we service companies and candidates across the United States. We are your best source for professional, value driven low cost recruitment services. Job Description Execute and enforce established data processes that relate to tracking additions and changes to the objects under governance stored in the data warehouse. Adding attributes, properly naming them and their lineage tracked from source systems through different stages in the data warehouse. Communicate frequently with users and developers, be knowledgeable about many aspects of data warehouse and contributing systems, and be able to recognize governance issues, which are cases where standards should be applied. No knowledge of any specific system is required, but experience with many systems, especially systems joined together by ETL and database connections is required. Maintaining Existing Processes: Updating, maintaining existing processes and procedures Setting Up Controls, Processes: Working with different stakeholders (business, O&S, compliance etc.) to gather requirements, identify and create new processes and data governance controls Working in a SME capacity to educate and advise the stakeholders about best practices Implement data policies and standards to ensure that data is both acceptable and accurate Qualifications Experience working at a financial services company or comparable experience working as an advisor to a financial services company Experience designing and implementing data quality and data governance solutions including platforms and supporting data processes Knowledge of technical architecture design and a good understanding of technology tools and components (middleware, database, reporting tools, etc.) in financial systems architecture Experience in all phases of the technology life cycle, including requirements definition, data architecture design, conversion and testing Strong organizational, analytical, communication and technical writing skills Ability to research emerging issues, including regulations, industry practices, and new technologies Strong written and oral communication skills Excellent problem-solving and quantitative skills Solid work ethic, self-driven, and team player with the ability to work with minimal supervision Some travel to various office locations as needed Additional Information Must be a US citizen or Green Card holder All your information will be kept confidential according to EEO guidelines.

Job Description VIP Automotive Group of Long Island is known for its exceptional leadership and customer-focused culture. Join our team for a professional work environment, continuous training, and the opportunity to be part of one of Long Island's most successful auto groups. At VIP, our purpose is to create exceptional value and experiences for every customer, surpassing our competitors. Our mission is to be the foremost provider of automotive sales and service, empowering our staff to deliver memorable customer experiences. Our team members enjoy a positive working environment with opportunities for professional growth through training and advancement from within the organization. Click Link below to learn more about our group and dealership - VIP Automotive Group Database Administrator (Full-Time) Salary: $35.00 - $50.00/hour (based on experience) Location: [Insert location or "On-site/Remote/Hybrid"] Schedule: Full-Time Are you a tech-savvy problem solver with a solid IT background? We are seeking a skilled and detail-oriented Database Administrator (DBA) to join our team and take ownership of our database systems. You will play a critical role in setting up and maintaining the structure, security, and integrity of our data environment. Key Responsibilities: Database Installation & Configuration: Set up and configure database systems for optimal performance and integration. Performance Monitoring & Tuning: Identify bottlenecks and implement improvements to ensure peak efficiency. Backup & Recovery: Establish and maintain robust backup strategies to ensure data preservation. Security Management: Control user access, enforce security protocols, and comply with data protection standards. Data Integrity & Availability: Guarantee consistent and accurate data through regular audits and error-checking. Capacity Planning: Anticipate storage needs and plan for future scalability. Troubleshooting & Support: Resolve database-related issues and provide ongoing technical support. Patching & Upgrades: Apply updates and patches to ensure systems are current and secure. Documentation: Maintain comprehensive and up-to-date documentation for all database systems and procedures. Team Collaboration: Partner with developers, IT teams, and stakeholders to deliver effective database solutions. ✅ Qualifications: Strong IT background with experience in database administration Proficiency in one or more database platforms (e.g., Oracle, SQL Server, MySQL, PostgreSQL) Knowledge of FTP, data security protocols, and system optimization Excellent problem-solving skills and attention to detail Ability to manage multiple priorities in a fast-paced environment Benefits Include: Medical and Dental Insurance 401(k) Retirement Plan Employee Discounts on Vehicle Purchases, Parts, and Service Paid Time Off Supplemental Benefit Plans (Short-Term Disability, Long-Term Disability, Supplemental Life Insurance) Comprehensive Employee Recognition Programs Opportunities for Career Advancement Professional Development Assistance Retirement Plan Schedule: Monday to Friday

Production support experience in database administration of DB2, ADABAS, Natural, IMS & CA-Datacom Production support of all database issues and integration jobs Production support for DB2 & Direct Connect Provide on-call 24/7 Incident Response to database issues from production monitoring tools, Command Center personnel and Application Development Analysts Generate DDM for ADABAS Optimize DB2 resource utilization by tuning queries (static and dynamic), making appropriate index recommendations and configuration parameter changes DB2 Connect 64-bit client installs Handle IMS Resource Lock Manager messages Participate in Disaster Recovery Exercise Continuously monitor database performance and take steps pro-actively to ensure a good database performance Installation, testing and deployment of IMS maintenance and upgrades Installation, testing and deployment of z/OS OEM software maintenance and upgrades Installation, testing and deployment of DB2 and/or CICS maintenance and upgrades Installation, testing and deployment of CA-Datacom maintenance and upgrades Create policies, standards and procedures for the database system support and usage Interface with external partners, customers and vendors Qualifications Knowledge of IMS system internals Knowledge of, and experience using IMS commands to start and stop IMS, alter bufferpools, perform recovery, list threads and determine their status, and manipulate IMS connections with other subsystems (including CICS, IMS, DB2 and other database systems) Knowledge of mainframe infrastructure to include experience or familiarity with IBM mainframe tools and jobs: TSO, JCL, SDSF, ISPF, CICS, IMS/DB, IMS/DC DB2, z/OS, WLM SMP/E, IDCAMS, IEBCOPY, DBCTL Additional Information Job Status: Full Time Eligiblity: GC or US Citizens Share the Profiles to **************************** Contact: ************ Keep the subject line with Job Title and Location

Our client represents the connected world, offering innovative and customer-centric information technology experiences, enabling Enterprises, Associates, and Society to Rise™. They are a USD 6 billion company with 163,000+ professionals across 90 countries, helping 1279 global customers, including Fortune 500 companies. They focus on leveraging next-generation technologies, including 5G, Blockchain, Metaverse, Quantum Computing, Cybersecurity, Artificial Intelligence, and more, on enabling end-to-end digital transformation for global customers. Our client is one of the fastest-growing brands and among the top 7 IT service providers globally. Our client has consistently emerged as a leader in sustainability and is recognized amongst the ‘2021 Global 100 Most sustainable corporations in the World by Corporate Knights. We are currently searching for a DBA Linux: Responsibilities Attention to alerts, incidents and monitoring. Review of changes and incident prevention. Database administration (installation, configuration, updating, monitoring). Server migration and database tuning. 24x7 technical support. Requirements DB2 experience (versions 11.1 and 11.5). Knowledge in HADR. AIX, Linux and Windows operating systems. Desired TLS and Data Transparent Encryption security configuration. Backups via API-TSM. Languages Advanced Oral English. Native Spanish. Note: Hybrid (3 days on-site, 2 remote). There are 2 addresses for the location. Lorenzo Boturini Offices Plaza Offices. Could be any of those. Boturini:Lorenzo Boturini 206, Tránsito, Cuauhtémoc, 06820 Ciudad de México, CDMX Plaza: Blvd. M, Perif. Blvd. Manuel Ávila Camacho 1, Miguel Hidalgo, 11560 CDMX If you meet these qualifications and are pursuing new challenges, Start your application to join an award-winning employer. Explore all our job openings | Sequoia Career's Page: ***************************************** Requirements DB2 experience (versions 11.1 and 11.5). Knowledge in HADR. AIX, Linux and Windows operating systems.

Expertise in MySQL and PostgreSQL is a mandatory requirement. The client is open to flexibility regarding other technical skills. Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments. Manage Replication solutions for each Database based on application requirement for proper High Availability. Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2). Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation. Design and implement comprehensive monitoring and alerting systems (CloudWatch , PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes. Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments. Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance. Work closely with DevSecOps to ensure timely application of security patches and upgrades. Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime. Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders. Good with Shell Scripting or Python. Good with linux administration. Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments. Manage Replication solutions for each Database based on application requirement for proper HighAvailability. Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2). Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation. Design and implement comprehensive monitoring and alerting systems (CloudWatch , PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes. Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments. Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance. Work closely with DevSecOps to ensure timely application of security patches and upgrades. Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime. Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders. Good with Shell Scripting or Python. Good with linux administration. Roles & Responsibilities Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments. Manage Replication solutions for each Database based on application requirement for proper HighAvailability. Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2). Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation. Design and implement comprehensive monitoring and alerting systems (CloudWatch , PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes. Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments. Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance. Work closely with DevSecOps to ensure timely application of security patches and upgrades. Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime. Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders. Good with Shell Scripting or Python. Good with linux administration.

Database developer to support front end systems (as needed by developers across the organization, in support of web services, third party, or internal development needs) to the exclusion of reporting needs by other departments. Developed code includes but is not limited to PL/SQL in the form of Triggers, Procedures, Functions, & Materialized Views. Generates custom driven applications for intra-department use for business users in a rapid application development platform (primarily APEX). Responsible for functional testing and deployment of code through the development life cycle. Works with end-users to obtain business requirements. Responsible for developing, testing, improving, and maintaining new and existing processes to help users retrieve data effectively. Collaborates with administrators and business users to provide technical support and identify new requirements. Responsibilities Responsibilities: Design stable, reliable and effective database processes. Solve database usage issues and malfunctions. Gather user requirements and identify new features. Provide data management support to users. Ensure all database programs meet company and performance requirements. Research and suggest new database products, services, and protocols. Requirements and skills In-depth understanding of data management (e.g. permissions, security, and monitoring) Excellent analytical and organization skills An ability to understand front-end user requirements and a problem-solving attitude Excellent verbal and written communication skills Assumes responsibility for related duties as required or assigned. Stays informed regarding current computer technologies and relational database management systems with related business trends and developments. Consults with respective IT management in analyzing business functions and management needs and seeks new and more effective solutions. Seeks out new systems and software that reduces processing time and/or provides better information availability and decision-making capability. Job Type: Full-time Pay: From $115,000- 128,000 yearly Expected hours: 40 per week Benefits: Dental insurance Health insurance Paid time off Vision insurance Paid time off (PTO) Various health insurance options & wellness plans Required Knowledge Considerable knowledge of on-line and design of computer applications. Require Experience One to three years of database development/administration experience. Skills/Abilities Strong creative and analytical thinking skills. Well organized with strong project management skills. Good interpersonal and supervisory abilities. Ability to train and provide aid others.

Our client located in southern Connecticut, commutable from NYC is looking for MS SQL Database Administrators, on a consulting basis, to assist with a critical MS SQL Server Upgrade. Must attend in person interview. 8+ years of Microsoft SQL Server Database Administration Must have Financial Services experience Must have Microsoft SQL Server Certification Must be able to support, develop and troubleshoot PowerShell and T-SQL scripts Demonstrated experience migrating from MS SQL Server 2008 (Windows 2003) to MS SQL Server 2014 on a shared Windows 2012 platform Working knowledge of VMware

Technical Lead - IE07DE We're determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals - and to help others accomplish theirs, too. Join our team as we help shape the future. The Hartford is seeking a .NET and SQL Tech Lead to join the Global Specialty IT team supporting our Finance applications. You will have the opportunity to work on highly visible and critical financial system integrations. You will gain insight into the numbers behind how the insurance industry functions. You will be a part of our modernization journey adopting DevOps practices, and Agile methodologies. You will be leading the engineering of business requirements. This role will have a Hybrid work schedule, with the expectation of working in an office 3 days a week (Tuesday through Thursday). Responsibilities + Provide technical leadership and enforce the vision of the application architecture + Skilled in Power BI and SSRS report development, including drill-down, drill-through, sub-reports, and custom expressions. Experienced in designing, developing, and turning raw data into actionable insights using interactive dashboards and reports. + Safeguard the integrity of the application environment in alliance with architects and other tech leads + Participate in all parts of SDLC- Analysis, Design, Development, Testing and Deployment. + Design and develop complex SQL, SSIS, SSRS code after writing detailed technical design specification. + Writing Scalable code in .NET (C#) application. + Drive technical innovation through newly identified and leading technologies + Possess functional knowledge of Financial systems and work with Business and deliver with highest technical quality. + Support and quickly respond to Production issues and requirements especially during month-end. + Manage, Integrate and deploy code in multiple environments. + Support financial month-end activities. + Prepare comprehensive technical requirements for the development team and oversee their completion. Qualifications + Must be authorized to work in the US now and in the future. + Develop and maintain robust SSIS ETL workflows for diverse data sources, advanced data transformations, and automation. + Bachelor's Degree with 8+ years developing SQL and .NET code. + Experience leading development efforts of a complex system. + Strong knowledge in SQL, SSIS and SSRS development. + Strong knowledge in .NET (C#) and Visual Studio. + Strong Troubleshooting skills and ability to reverse engineer SQL and .NET code. + Experience supporting Financial systems. + Be self-motivated, analytical, and skilled in research. Manage multiple priorities effectively, focus on details, and maintain a clear overall perspective. + Experience designing and implementing Microservices or API-based integrations. + Experience with DevOps practices including but not limited to continuous integration (CI) and continuous deployment (CD) concepts and tools; familiarity with automated testing and code analysis tools. + A strong desire to stay on top of technology trends in the AI, cloud space as it relates to supporting Financial systems in AWS. + Strong skills in Excel and MS 365. + The candidate must have strong written and verbal communication, presentation, and technical writing skills with ability to effectively communicate solution recommendations and influence key stakeholders. Candidate must be authorized to work in the US without company sponsorship. The company will not support the STEM OPT I-983 Training Plan endorsement for this position. Compensation The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford's total compensation package for employees. Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition. The annualized base pay range for this role is: $115,200 - $172,800 Equal Opportunity Employer/Sex/Race/Color/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age About Us (************************************* | Our Culture (******************************************************* | What It's Like to Work Here (************************************************** | Perks & Benefits (********************************************* Every day, a day to do right. Showing up for people isn't just what we do. It's who we are - and have been for more than 200 years. We're devoted to finding innovative ways to serve our customers, communities and employees-continually asking ourselves what more we can do. Is our policy language as simple and inclusive as it can be? Can we better help businesses navigate our ever-changing world? What else can we do to destigmatize mental health in the workplace? Can we make our communities more equitable? That we can rise to the challenge of these questions is due in no small part to our company values that our employees have shaped and defined. And while how we contribute looks different for each of us, it's these values that drive all of us to do more and to do better every day. About Us (************************************* Our Culture What It's Like to Work Here (************************************************** Perks & Benefits Legal Notice (***************************************** Accessibility Statement Producer Compensation (************************************************** EEO Privacy Policy (************************************************** California Privacy Policy Your California Privacy Choices (****************************************************** International Privacy Policy Canadian Privacy Policy (**************************************************** Unincorporated Areas of LA County, CA (Applicant Information) MA Applicant Notice (******************************************** Hartford India Prospective Personnel Privacy Notice

Pyramid is a leading Information Technology Consulting services company headquartered in metropolitan Atlanta, GA with prime emphasis on the following service offerings: • Staff Augmentation • Lifecycle IT solutions o Application Development & Support o Outsourced Testing • Mobile Development and Test Automation The company was incorporated in the State of Georgia in 1996 and has grown to over 2500 Information Technology consultants serving clients across the United States and around the globe. In addition to Atlanta, Pyramid has offices worldwide including Charlotte, NC; Chicago, IL; Dallas, TX; Richmond, VA; San Francisco, CA and Somerset, NJ in the United States, London in the United Kingdom, Singapore, and three offices in India (New Delhi, Hyderabad and Chandigargh). Pyramid has been ranked by Staffing Industry Analysts as one of the largest diversity staffing firms specializing in IT and among the fastest growing U.S. staffing firm overall. In addition, Pyramid is a previous winner of the National Minority Supplier Development Council's Supplier of the Year and has won numerous Supplier of the Year awards from the Georgia Minority Supplier Development Council. see less Specialties IT Staff Augmentation, Application Management Services, Enterprise Project Solutions, Mobile Development, Mobile Test Automation, Product and Engineering Services, Enterprise Mobility, Test Automation, QA - Manual and Automated Testing, QA Strategy Website ************************ Industry Information Technology and Services Type Privately Held Company Size 1001-5000 employees Founded 1996 Job Description Title: Oracle DBA with NetApp Location: Englewood Cliffs, NJ Duration: 6 Months No of Positions: 1 Rate: $9k / Month Minimum 5 Years of experience • Strong Core DBA Skills 8i,9i,10g/11g R1 & R2 (like Database creation, User management, Memory management etc) • Experience in Backup/Recovery • Experience/Exposure in Oracle Enterprise Manager, RMAN, Dataguard, Performance tuning, Load Balancing • Experience with NetApp Cloning is a Must • Experience with Oracle security is a plus (Lable Secuirty, Oracle Vault) • Experience in Real Application Cluster (RAC) & Automatic Storage management (ASM) • Experience in Installation, Maintenance/Support of Production and Development Environment • Database Upgrade experience • Expert understanding of technology systems and infrastructure • Expert knowledge of technology and software design and deployment principles • Provides recommendations on direction to Senior IT Management • Works with internal and external organizations solving complex problems and handling large scale projects • Works with vendors and suppliers. • Provides detailed, day-to-day direction to development teams to design and build quality applications using standard patterns, architectures, and best practices. • Manages and mentors engineers both on and off-shore • Provides Level 3 (advanced) technical expertise; Oversight and accountability for resolution of outages, service level issues, and user/customer support needs in coordination with other support groups and teams • Ensures technical documentation is kept up to date (run books, process diagrams, system information, technical documents) • Maintains overall responsibility for quality of production deployments • Oversees future implementations and/or upgrades and ensure that support standards are in place • Defines proactive activities and tasks required for optimization of stability, performance and architecture • Perform special projects and departmental initiatives as needed • Responsible to drive uptime requirements • Good hands-on technical knowledge. Additional Information All your inform Thanks and Regards Ravi Jaiswal Pyramid Consulting, Inc. SEI-CMMI Level 3 11100, Atlantis Place, Alpharetta, GA - 30022 Cell: ********** Work: ************(Desk) fax: ************ Email: [email protected] USA | UK | India ation will be kept confidential according to EEO guidelines.

ARKA Group L.P. (“ARKA”) is an advanced technologies company serving the U.S. military, intelligence community, and commercial space industry delivering next-generation solutions to support the national security space enterprise. Built on more than six decades of excellence, ARKA brings modern approaches and a culture of innovation to the challenges of today. Join the ARKA team to learn how Beyond Begins Here. Discover your next career opportunity now! Position Overview: In this position, you will be part of a talented and growing IT team and take responsibility for a wide range of assignments supporting on-premises and hosted data. In doing so, you'll have the opportunity to apply your expert level knowledge of database architecture, standards, programming, and optimization techniques. You will build database configurations, maintain data flows and related processes, optimize servers and databases, increase automation, usability, and create technical documentation. This will require use of complex database security techniques, backup, restoration, migration strategies, risk management, and disaster recovery. This opportunity will afford the successful candidate to influence, grow and evolve with the organization as we transform into a new corporation. Responsibilities: Installing and regularly upgrading Oracle and SQL Server Create and manage database tablespaces Database user account creation and management Database and database infrastructure security configurations Support security teams with required security configurations, justifications, and Information assurance vulnerability management (IAVM) tasks Manage Oracle and SQL Server Database instances on Linux and Windows operating systems Expertise with Windows OS configuration and management Provide full system administration and database administration support for the SQL Server and Oracle environment Provide support for development, test and production Oracle/SQL Server enterprise relational database management systems Required Qualifications: Minimum experience 5 years performing in an Oracle 19c and SQL Server 2019 DBA role Experience administering Business Management applications and knowledge of Business application architecture Knowledge of standard integration platforms and REST APIs Strong knowledge of database roles/security best practices Problem solving plus analytical skills troubleshooting complex database issues Demonstrated experience in the following: Scripting Experience - (ie:Shell, Bash, Python, PowerShell.) Application servers (ie: RedHat JBOSS, Apache, IIS) database/application performance tuning in Oracle and SQL Server Reading execution plans, query store, extended events Backup and Recovery Tools: RMAN, pg_dump, veeam TSQL Scripts and writing complex queries Working on reorg/rebuild indexes and fragmentation issues GUI Tools - SSMS, SQL Developer, Toad SQL Tools - SSIS SSRS Preferred Qualifications: Experience working in a DoD environment with associated clearances is preferred Experience with automated system configuration Experience with PostgreSQL Knowledge of Data Warehouse concepts Location: Danbury, CT Located in beautiful Fairfield County, Danbury offers a diverse economy, wonderful parks, cultural attractions, an impressive mix of private and public educational institutions and a vibrant arts scene. Our facility is nestled among a remarkable selection of communities to call home all with varying price points to fit many different budgets. We're close to New York City, Boston, and other major cities - great for day trips and weekend getaways. Our lovely seasons along with award-winning institutions, colleges, cultural events, and a genuine sense of community brings a diverse population to the beautiful state of Connecticut! What We Offer: Comprehensive medical/vision/dental insurance packages Company contributions to qualified HSA accounts 401k retirement plan with industry leading company contributions 3 weeks of vacation accrual per year plus time off for sick leave and unscheduled life events 13 paid holidays Upfront tuition assistance for approved degree programs Annual bonus program based on company and employee performance Company paid life insurance, AD&D, Short-Term and Long-Term disability insurance 4 weeks paid Parental Leave Employee assistance program (EAP) EHS/Environmental Requirements: This job operates in a professional office environment. While performing the duties of this job, the employee routinely is required to use hands to keyboard, communicate, listen to, and interpret instructions and remain stationary for extended periods of the time. This would require the ability to move around the campus and occasionally move/lift items weighing up to 25 lbs. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job. Applicants are invited to apply for a reasonable accommodation to perform the essential duties of the job. To apply, send a request to ***************** or contact ************ and press 2 for Human Resources. ITC & Security Clearance Requirements: This position requires the ability to obtain and maintain a U.S. Government Security Clearance. This position also requires U.S. citizenship in support of contract requirements. Additionally, if you are a dual citizen (a citizen of the U.S. and another country), the Company must obtain approval for you to have access to the information required for this position. You will not be able to begin employment until such approval is obtained and this may take several months. Visa Restrictions: No visa sponsorship is available for this position. Pre-employment Screenings: Employment with any ARKA companies in the U.S. is contingent upon satisfactory completion of several pre-employment requirements to include a credit check, background check, and drug screen.

Mindlance is a national recruiting company which partners with many of the leading employers in the Life Sciences, IT, and Financial Services sectors, feel free to check us out at ************************* Job Title: DBA Location: Englewood Cliffs, NJ DURATION:- 12+ Months Local candidate only on W2. Job Description • The lead DBA role requires hands-on production database administration skills, deep technical expertise MySQL including various third party versions like Percona Server. • The DBA will work closely with the development teams and operations team to manage, support and maintain more than 50 instances on MySQL Database across Digital platform. Required Technical & Leadership Skill Sets • BS degree or higher in Computer Science with a minimum of 5+ years hands-on database administration experience on MySQL Databases deployed on Linux servers • Sound understanding on installation, configuration, patching, supporting and upgrading MySQL servers including Percona servers • Strong understanding on MySQL backup and recovery strategies. • Familiar with MySQL Enterprise backup and recovery tools including 3rd party backup solutions like Percona xtrabackup • Strong understanding on MySQL replication including multi data-center replication for High Availability • Should be good with query tuning and Performance Optimization • Estimate database capacities, develop methods for monitoring and maintenance of database instances • Minimum 3+ yrs experience as Production Database Administrator • Should be good with MySQL Stored procedures and functions ? Good exposure to linux operating system • Should have 3+ years of experience on writing linux shell scripts , perl scripts etc Languages and Software Packages: • Languages : Linux shell scripting, perl, python • Database : MySQL, MySQL Cluster, Oracle, Redis • Tools : Percona toolkit, MySQL Utilities ? Development Methodologies: Agile development Responsibilities: Personal Skills: • Strong experience working with multi-site development teams. • Strong Communication skills (verbal and written) with an ability to work in a highly collaborative, multi-country/time zone environment. • Good organizational skills with the ability to track and prioritize numerous tasks. Proactive personality with a proven track record of following through and delivering on responsibilities. Highly adaptive and capable of being an individual contributor and working as part of an extended team. Additional Information Thanks & Regards, Shipra Chauhan | Team Recruitment | Mindlance Inc | ************.

Pyramid is a leading Information Technology Consulting services company headquartered in metropolitan Atlanta, GA with prime emphasis on the following service offerings: • Staff Augmentation • Lifecycle IT solutions o Application Development & Support o Outsourced Testing • Mobile Development and Test Automation The company was incorporated in the State of Georgia in 1996 and has grown to over 2500 Information Technology consultants serving clients across the United States and around the globe. In addition to Atlanta, Pyramid has offices worldwide including Charlotte, NC; Chicago, IL; Dallas, TX; Richmond, VA; San Francisco, CA and Somerset, NJ in the United States, London in the United Kingdom, Singapore, and three offices in India (New Delhi, Hyderabad and Chandigargh). Pyramid has been ranked by Staffing Industry Analysts as one of the largest diversity staffing firms specializing in IT and among the fastest growing U.S. staffing firm overall. In addition, Pyramid is a previous winner of the National Minority Supplier Development Council's Supplier of the Year and has won numerous Supplier of the Year awards from the Georgia Minority Supplier Development Council.see less Specialties IT Staff Augmentation, Application Management Services, Enterprise Project Solutions, Mobile Development, Mobile Test Automation, Product and Engineering Services, Enterprise Mobility, Test Automation, QA - Manual and Automated Testing, QA Strategy Website ************************ Industry Information Technology and Services Type Privately Held Company Size 1001-5000 employees Founded 1996 Job Description Title: Oracle DBA with NetApp Location: Englewood Cliffs, NJ Duration: 6 Months No of Positions: 1 Rate: $9k / Month Minimum 5 Years of experience • Strong Core DBA Skills 8i,9i,10g/11g R1 & R2 (like Database creation, User management, Memory management etc) • Experience in Backup/Recovery • Experience/Exposure in Oracle Enterprise Manager, RMAN, Dataguard, Performance tuning, Load Balancing • Experience with NetApp Cloning is a Must • Experience with Oracle security is a plus (Lable Secuirty, Oracle Vault) • Experience in Real Application Cluster (RAC) & Automatic Storage management (ASM) • Experience in Installation, Maintenance/Support of Production and Development Environment • Database Upgrade experience • Expert understanding of technology systems and infrastructure • Expert knowledge of technology and software design and deployment principles • Provides recommendations on direction to Senior IT Management • Works with internal and external organizations solving complex problems and handling large scale projects • Works with vendors and suppliers. • Provides detailed, day-to-day direction to development teams to design and build quality applications using standard patterns, architectures, and best practices. • Manages and mentors engineers both on and off-shore • Provides Level 3 (advanced) technical expertise; Oversight and accountability for resolution of outages, service level issues, and user/customer support needs in coordination with other support groups and teams • Ensures technical documentation is kept up to date (run books, process diagrams, system information, technical documents) • Maintains overall responsibility for quality of production deployments • Oversees future implementations and/or upgrades and ensure that support standards are in place • Defines proactive activities and tasks required for optimization of stability, performance and architecture • Perform special projects and departmental initiatives as needed • Responsible to drive uptime requirements • Good hands-on technical knowledge. Additional Information All your inform Thanks and Regards Ravi Jaiswal Pyramid Consulting, Inc. SEI-CMMI Level 3 11100, Atlantis Place, Alpharetta, GA - 30022 Cell: ********** Work: ************(Desk) fax: ************ Email: [email protected] USA | UK | India ation will be kept confidential according to EEO guidelines.