Talent.com
Database Administrator / Modeler
Database Administrator / ModelerGamen Group • Hartford, CT, US
Database Administrator / Modeler

Database Administrator / Modeler

Gamen Group • Hartford, CT, US
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Looking for Industry-Leading Database Administrator / Modeler :

Are you an expert in database design and development who has a solid working knowledge of one more analytic tools including SAS, Alteryx, Tableau, Qlikview and programming languages such as C++, .NET, R, Java, Python, Perl etc.? Do you enjoy providing clients with the most efficient, technology-based solutions available? Are you committed to converting leading edge ideas into tangible results? If your answer is yes, please read on…

The Data Administrator / Modeler will be responsible for the design, creation, maintenance, backup, restore, and upgrade of Microsoft SQL Server (64 bit, 2005, 2008, 2012) databases as well as Oracle 11g client development databases. The Data Administrator / Modeler will manage third party external data sources, maintain technical relations with the vendors and build databases and applications to allow client service teams to access the data for enrichment and analytics purposes.

Responsibilities :

  • Design, size and document database architecture.
  • Build database schema, tables, procedures and permissions.
  • Set up data sharing and disk partitioning.
  • Create shell scripts for task automation.
  • Analyze, consolidate and tune database for optimal efficiency and performance.
  • Monitor systems and platforms for availability.
  • Oversee backup, clustering, mirroring, replication and failover.
  • Restore and recover corrupted databases.
  • Install and test upgrades and patches.
  • Implement security and encryption.
  • Troubleshoot and resolve production / development support issues.
  • Perform database management software system upgrades.
  • Control user access to databases and ensure connectivity to databases.
  • Develop disaster recovery procedures and documentation.
  • Design and implement database security model.
  • Fulfill ad hoc data analysis and data matching requests.
  • Review SQL code for compliance with coding and performance standards.
  • Perform database management software system upgrades.
  • Manage third party external data sources used by analytics teams for analytics, data enrichment and matching.
  • Represent advisory teams in client side technical meetings.
  • Translate business requirements into a logical and physical data models.
  • Develop and enhance database standards and integration with analytics tools.
  • Work closely with cross-functional development teams to help establish and enforce data quality standards and documentation across the analytics function.
  • Maintain relationships with external data providers and act as technical and data knowledge liaison with data providers.
  • Maintain knowledge of various data sources serving as the database expert and primary liaison for client teams.
  • This position may require up to 25% travel.

Qualifications :

  • 8 or more years of database administration and application development experience supporting Microsoft SQL Server, Oracle 11g and data analytics tools and technologies.
  • Long-term hands on experience as a SQL Server / Oracle DBA in both a Transactional and Data Warehousing environment in addition to extensive data modeling experience.
  • Knowledge and understanding of Oracle 10g, 11g including Import / Export functionality
  • Experience installing, configuring, troubleshooting, and supporting Windows 2008-2012 and Oracle 11g Servers.
  • Practical experience using SQL Server 2008-2012 database management tools, which includes Enterprise Manager and SQL Server Management Studio, Query Analyzer, SQL Server Profiler and Data Transformation Service and / or SQL Server Integration and Reporting Services.
  • Experience building a Server Cluster and installing SQL Server in a Clustered environment (Active / Active) for all versions of SQL Server.
  • Logical and physical database design.
  • Experience with Quest Lite-speed for Backup compression.
  • Well versed with writing and tuning PL-SQL procedures and DTS / SSIS packages.
  • Knowledge of SAS and Alteryx products is highly desired; however, experience supporting analytics type projects is a requirement
  • Experience with store databases columnar (such as Kognitio) and working in a massively parallel processing (MPP) environment a plus
  • Proficient usage and experience with advanced query language.
  • Proficiency in solution development and methodology using industry standard tools.
  • MCSE or MCDBA Certification preferred but not required.
  • Exceptional written and oral communication abilities including strong interpersonal skills with the ability to present ideas in user-friendly language both written and oral
  • Strong technical documentation skills
  • Successful experience working in a team-oriented, collaborative environment
  • Proven analytical and problem-solving abilities
  • Bachelor’s degree in computer information systems, science, engineering or equivalent field.
    • [job_alerts.create_a_job]

    Database Administrator Modeler • Hartford, CT, US

    [internal_linking.similar_jobs]
    Construction Estimator - Senior Level

    Construction Estimator - Senior Level

    1Confidential, Inc. • Springfield, MA, US
    [job_card.full_time]
    Position : Construction Estimator Senior level.Prepare detailed cost estimates based on the construction drawings and specifications. Communicate bids and scopes of work.Prepare detailed estimates by...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Head of Subsection - Data Prod Support 1

    Head of Subsection - Data Prod Support 1

    Munich RE • Hartford, CT, United States
    [job_card.full_time]
    Amelia, United States; Hartford, United States; New York, United States; Princeton, United States;.This position also requires sound technical skills, the ability to collaborate across teams both o...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Exposure Management NACP Lead Analyst

    Exposure Management NACP Lead Analyst

    Beazley Group • West Hartford, CT, United States
    [job_card.full_time]
    Exposure Management, General Management.Exposure Management Property Risks Lead.Property Underwriting and Claims Operations (UCO), IT. North America Commercial Property (NACP).Analysts for Catastrop...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Locals Only- Certified Coding Specialist.

    Locals Only- Certified Coding Specialist.

    Lancesoft INC • Hartford, CT, US
    [job_card.full_time]
    Job Title : Certified Coding Specialist.Contract Length : 12 weeks (with possible extension).Shift : Days 5x8-Hour (8a-4 : 30p). Associate’s Degree or equivalent experience.Seeks clarification from...[show_more]
    [last_updated.last_updated_30] • [promoted]
    INTERN

    INTERN

    EVOLVEIMMUNE THERAPEUTICS INC • Branford, CT, US
    [job_card.part_time]
    EvolveImmune Therapeutics is a next-generation immunotherapy company that is pioneering a new class of precision cancer medicines to transform patient outcomes, compared to current solid tumor ther...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Design Sales Representative

    Design Sales Representative

    3 Day Blinds • Springfield, MA, US
    [job_card.full_time]
    Day Blinds is a national retailer and manufacturer of quality, custom-made blinds, shades, draperies, and shutters.We are proud to be part of the Hunter Douglas family of brands.Over the last 40 ye...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Database Administrator

    Database Administrator

    Sunrise Systems • Hartford, Connecticut, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Job Title : Database Administrator.Location : Hartford, CT(Hybrid).Duration : 06 months on W2 Contract.The DBA will lead technical support for the Snowflake environment, ensuring its performance, avai...[show_more]
    [last_updated.last_updated_30]
    Travel Mammography Tech - $2,641 per week in Pittsfield, MA

    Travel Mammography Tech - $2,641 per week in Pittsfield, MA

    AlliedTravelCareers • Springfield, Massachusetts, US
    [job_card.full_time]
    Atlas Medstaff is currently seeking candidates in the Mammo Tech (Mammo Tech) profession for a 13 week contract in the Pittsfield, Massachusetts area. Atlas Medstaff is a premier staffing firm dedic...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Design Sales Representative

    Design Sales Representative

    3 Day Blinds (Sales) • Springfield, MA, US
    [job_card.full_time]
    Day Blinds is a national retailer and manufacturer of quality, custom-made blinds, shades, draperies, and shutters.We are proud to be part of the Hunter Douglas family of brands.Over the last 40 ye...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Software Engineer, Cloud

    Senior Software Engineer, Cloud

    Hyperfine • Guilford, CT, US
    [job_card.full_time]
    Nasdaq : HYPR) is the groundbreaking health technology company that has redefined brain imaging with the.FDA-cleared, portable, ultra-low-field, magnetic resonance brain imaging system capable of pr...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Excel / VBA Modeling Consultant

    Excel / VBA Modeling Consultant

    Lincoln Financial Services • Hartford, CT, United States
    [job_card.full_time]
    We are excited to bring on an Excel / VBA Modeling Consultant to join our Retail Solutions business in a hybrid work environment. We are open to candidates in the following key city locations : Charlot...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Analyst, Alternatives (HYBRID)

    Senior Analyst, Alternatives (HYBRID)

    Selective Insurance • Farmington, CT, United States
    [job_card.full_time]
    At Selective, we don't just insure uniquely, we employ uniqueness.Selective's unique position as both a leading insurance group and an employer of choice is recognized in a wide variety of awards a...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Medical Billing Analyst

    Medical Billing Analyst

    Midstate Radiology Associates • Wallingford, CT, US
    [job_card.full_time]
    Join Midstate Radiology Associates (MRA) as a Full Time Medical Billing Analyst in Wallingford, CT.Position Schedule : Mon - Fri, 1st Shift (8 : 00am - 4 : 30pm or 8 : 30am - 5 : 00pm).For complete listing ...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Remote Financial Analyst - AI Trainer ($50-$60 / hour)

    Remote Financial Analyst - AI Trainer ($50-$60 / hour)

    Data Annotation • Wallingford Center, Connecticut
    [filters.remote]
    [job_card.full_time] +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Inspection Technology Leader

    Inspection Technology Leader

    Pursuit Aerospace • South Windsor, CT, United States
    [job_card.full_time]
    As a global manufacturer of complex aircraft engine components, Pursuit Aerospace is founded on a commitment to relentless, continuous, operational improvement and extraordinary customer service.We...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Junior Systems Administrator

    Junior Systems Administrator

    ASG Information Technologies • Wallingford, CT, US
    [job_card.full_time]
    Salary : $60k+ experience depending.ASG Information Technologies in Wallingford, one of Connecticuts most recognized MSP, is expanding again. We are looking for a well rounded individual who have sol...[show_more]
    [last_updated.last_updated_30] • [promoted]
    General Application

    General Application

    Phoenix Manufacturing Inc. • Enfield, CT, US
    [job_card.full_time]
    Don't See the Perfect Role? We Still Want to Hear From You.While we try to keep our careers page updated with all immediate openings, we know that top talent—like you—doesn't al...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Construction Estimator

    Construction Estimator

    AmeriTech Contracting LLC • Berlin, CT, US
    [job_card.full_time]
    Construction Estimator-Job Description.Responsible for preparing accurate cost estimates across all design stages, coordinating with subcontractors, suppliers, and internal teams, and supporting co...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]