Database Analyst – SQL Programmer-516863

Job Listing No: 9740000

Database Analyst – SQL Programmer-516863

?Job Description:ions in Minnesota, Iowa, Illinois, Nebraska, and South Dakota. A leader in food production for more than 40 years, Christensen Farms is an organization that offers an ever-evolving, highly collaborative and challenging work environment. We believe in hiring talented people to help us in our mission to deliver a high quality, safe and wholesome pork product to consumers while giving each of our employees the opportunity to be a part of an outstanding and professional work setting.Position Overview:The Database Analyst serves as a technical advisor, developer, manager, and coordinator of databases and related systems designed to meet the needs of the Christensen Farms business.This person is in charge of programming automation scripts that provide regular maintenance to company databases, analyzing business requirements to suggest improvements, providing end-user support, and responding to ticket requests as needed. This person interacts with other information technology staff and department managers, in addition to working directly with end users, analysts, and senior management. The Database Analyst/Programmer creates database mappings to transform data from multiple systems, takes part in setting up connectivity to data sources, modifies database packages to fit company and project requirements, and creates custom databases/structures to achieve all organizational goals. ?This person is also responsible for creating custom reports, assisting other staff as they develop reports, and provides direction and leadership on the future of corporate reports and dashboards.The Database Analyst/Programmer optimizes databases by developing scripts and code to increase network performance and overall productivity. This person must maintain accurate documentation of database features/functionality and create detailed reports based on findings. This role will be responsible for installing and updating database systems, designing, running and troubleshooting database applications and improving database performance by analyzing existing database systems and processes.Must be able to manage multiple projects concurrently and balance priorities across them; requires strong problem-solving skills, ability to meet deadlines under significant time pressures, maintain confidentiality and focus, and work closely with a wide variety of people. ?Working closely with a wide variety of people requires excellent communication skills both verbally and in written format. ?May be called upon to work extended hours. ?Limited travel is required.Major Areas of Responsibility:Installing and upgrading the MS SQL Server application stack including database and related applicationsAllocating system storage and planning future storage requirements for the database systemModifying database structuresManaging users and maintaining system securityEnsuring compliance with database vendor license agreementMonitoring and optimizing the performance of the databasePlanning, implementing and testing backup and recovery of database systemsPeriodic refresh of development and quality assurance environments from productionContacting database vendor for technical supportProactive management, monitoring, and alerting of all relevant systems under the care of the positionScripting, scheduling, and automation of database and system jobsDeveloping, testing, and maintaining SSIS ETL packages, system jobs, and corporate reports in SSRS and Crystal ReportsDeveloping, testing, maintaining and tuning of data structures, functions, procedures, and viewsAnalyzing data and recommending appropriate algorithms and data structures to support business data analysis and reporting needsFunctional requirements gathering (how an application or system is to behave)Technical requirements gatheringInvestigating and repairing data integrity issues caused by applications or developersDevelopment of data integrity standardsMaintain data dictionary by revising and entering definitionsDesign, write, test, and debug database stored procedures and complex queries to extract, calculate or manipulate informationProgram, maintain scripts, troubleshoot, and tune performance of managed systemsAdminister multiple SQL Server and EssBase databases on the Windows platform by setting up and maintaining server software and upgrades, managing user accounts, and ensuring proper levels of security are established for internal developers and end usersDesign databases based on user specificationsEstablish triggers, storage procedures, indexing and data integrity controls in order to provide the fastest access to time sensitive data without impacting server performanceProvide technical expertise for technology and technology support staff involved in team/project based database and web applications development.Maintain confidence and protect operations by keeping information confidentialMaintain technical knowledge by attending educational workshops; reviewing publications; establishing personal networks; participating in technical societiesPerform other duties incidental to the work describedEducation, Training and Experience Requirements:Minimum formal education required: Bachelor's degree in database analysis, software programming, computer science, or a related field.Minimum number of years of prior job experience required: 6+ years of progressive experience in Microsoft SQL Server database administration.Specialized Training requirements: Microsoft Certification MCSE or MCSA.Required skills:Extensive experience managing the full suite of Microsoft SQL Server applications including SQL Server, SSIS, SSRS, and TSQLComprehensive experience with log shipping and replicationExtensive reporting, development, and analysis experience using the Microsoft SQL application stackExpert knowledge of MSSQL Server RDBMS concepts and fundamentalsMust have strong organizational skills and attention to detailExperience with relational data modeling toolsMust be able work independently and think critically on own with minimal supervisionStrong quantitative and analytical skills with proven resultsStrong problem solving and conceptual thinking abilitiesExcellent verbal and written communication and interpersonal abilitiesDemonstrated time management and prioritization skills, investigative and decision-making skillsAgricultural experience a plus.Technical experience in the following not required, but a plus:OLAP cube design and deploymentHyperion EssBase development, management, and/or monitoringFormal project management trainingApplication reporting with ArcPlanMicrosoft Team Foundation Services source control and build platformMicrosoft Project experienceActive Directory managementBusiness IntelligenceMicrosoft Access database application developmentVMWareVeeam

Apply for this job.

Similar Jobs For "Database Analyst – SQL Programmer-516863"

 Jobs by Indeed job search

Associate Strategic Product Manager - Product Data Analyst

Company: Northern Trust Corp.
Location: Chicago, IL
Manage external database reviews, ensuring timely and relevant content updates. The Product Data Analyst plays a vital role in supporting development and… To apply for this job vacancy in Northern Trust Corp. you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 5 hours ago

SQL Developer

Company: Solware it technologies
Location: McKinney, TX
(1) years’ experience working in a SSIS and SQL Database. Experience in systems design and a solid understanding of development, database development, testing,… To apply for this job vacancy in Solware it technologies you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 5 hours ago

PL/SQL Developer

Company: Orb IT People
Location: Austin, TX
Referential integrity and database tuning techniques. The Developer/Analyst will perform advanced analysis and computer programming work involving all technical… To apply for this job vacancy in Orb IT People you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 4 hours ago

Data Analyst

Company: Grubhub
Location: Boston, MA
Develop a deep understanding of the LevelUp architecture, its related database tables and the interactions between them. 1-3 years in analytics role. To apply for this job vacancy in Grubhub you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 29 minutes ago

Data Analyst

Company: Tom Steyer 2020
Location: San Francisco, CA
Tom Steyer 2020 is looking for a data analyst to join our Digital and Paid Media teams. Put together a dashboard joining our database of supporters to the… To apply for this job vacancy in Tom Steyer 2020 you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 59 minutes ago

Note: This job listing with titled "Database Analyst – SQL Programmer-516863" was indexed from different job portals. This job might be expired or closed for accepting CV's so we suggest to browse it from the new jobs menu of this site. Our website is an open community website for assisting job seeker so if you found some broken links or error in our site don't hesitate to contact us to fix the issue. Thank you for using our free services.