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 developmentVMWareVeeamApply for this job.