Database administration manager job description

American Farmland Trust is the only national organization that takes a holistic approach to agriculture, focusing on the land itself, the agricultural practices used on that land, and the farmers and ranchers who do the work. Since our founding in 1980, AFT has helped permanently protect over 6.5 million acres of agricultural lands, advanced environmentally-sound farming practices on millions of additional acres, and helped thousands of farm families make a go of it (primarily through programs that increase farm viability and/or enhance farmland access). Long a pioneering leader, AFT is now riding a new wave of growth, driven by agriculture's most pressing needs and opportunities.

We believe diversity drives innovation. We are inclusive. We embrace differences. We recognize and respect the fundamental value and dignity of all our employees. We celebrate the unique traditions, heritages, and experiences our employees bring to the workplace. We are committed to creating and sustaining an inclusive culture that promotes and values diversity, and where everyone feels empowered to bring their authentic selves to work every day.

We provide equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, expression or identity, national origin, age, disability, or genetics. In addition to federal law requirements, American Farmland Trust complies with applicable state and local laws governing nondiscrimination in employment in every location in which we have facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Reporting directly to the CFO and VP of Finance & Administration the Database Manager will lead and direct functions by designing, maintaining, and monitoring our current/future database systems.

As an integral part of the AFT team, the Database Manager is responsible for overseeing and maintaining database systems across the organization. The Database Manager plays a primary role in ensuring that all systems are running accurately, and staff are properly trained in the databases used. These currently include Microsoft Dynamics365, SharePoint and within the next year a new CRM on the Microsoft platform. The Database Manager will work with a third-party partner to implement new portions of systems. AFT is in the very early stages of Dynamics 365 adoption.
What You'll Be Working On
Design usage of database systems. Enhances the effectiveness of database tools and services. Help build the structure and design of the database. Enhance the scalability and performance of existing database structures and recommend improvements by aligning systems with business needs Monitor & improve database performance with testing and troubleshooting. Keep up to date with technological developments. Address database related queries from staff. Develop technical solutions for any problems related to database system. Conduct regular data auditing to maintain integrity of the database. Ensure data security. Conduct interviews with stakeholders to identify business requirements Set policies and standard operating procedures for database design and use Work with database developers to implement new tools and integrate with various systems or eliminate unnecessary systems. Champion use of Dynamics365 and SharePoint to all end users. Manage project timelines for implementation of new features.



The ideal candidate possesses:
Advanced knowledge of Microsoft products, specifically Dynamics 365 and SharePoint. In-depth knowledge of database technologies, architecture, data security and server management. Familiarity with CRM infrastructure and implementation. Strong analytical problem-solving skills. Ability to troubleshoot software and issues Advanced analytical organizational skills and attention to detail Excellent written and oral communication skills
Education & Experience
A bachelor's or higher in management information systems, computer science or a related field 5 years' experience in database management or similar role Experience with Microsoft Dynamics or Salesforce required.
Why you should apply
Be a part of a purpose-driven, committed, knowledgeable, high-performing, experienced and fun team A diverse and inclusive work environment A cause and mission you can be proud of Competitive compensation & Benefits Remote work opportunities Flexible scheduling
Ready to apply? If this job sounds like a fit for you, then click on the 'apply' button below.



PI193516926

TransCore (TRN), a subsidiary of ST Engineering, is seeking a full-time Manager, Database Administration to join our team in Orlando, FL.

TheManager, Database Administration is responsible for setting up, managing, and optimizing databases in support of Enterprise and External Web applications. This includes working closely with system managers and developers to add system functionality, tables, and data, optimizing systems for availability and performance, and contributing to system upgrades. The Manager is responsible for maintaining applications, processes, and maintenance procedures, performance tuning and documentation and management of changes to database operations.
Essential Duties and Responsibilities include the following but not limited to:



Setup, configure, and install database systems. Optimizes and tunes database systems. Pro-actively monitors performance and capacity. Performs data ports and data loads; monitors and tests data integrity as required. Backup, recovery, testing of recovery procedures, and archiving databases. Troubleshoots database issues and performs database impact analysis for proposed changes. Ensures that systems stay updated on all relevant patches and upgrades. Alter tables and schema structure as required. Serve as technical expert for database design and support issues. Works with the Application and Internet Development teams to develop stored procedures, triggers, and code to support enterprise applications as well as to enforce coding standards. Executes database release management processes and coordinates maintenance of development, testing, and production environments. Directly supervises staff. Responsibilities include interviewing, hiring, and training employees; planning, assigning, and directing work; appraising performance; rewarding and disciplining employees; addressing complaints and resolving problems. May perform other duties and responsibilities as assigned



Education
:
Bachelor's degree (B.A.) in computer science, engineering, or information management from four-year college or university or equivalent combination of education and work experience.


Required Skills & Experience:



At least five years of experience in Database Administration Microsoft Certified SQL Server Database Administrator Experience writing and optimizing complex SQL and T-SQL
Ability to dissect complex queries with sub-queries Able to debug T-SQL code issues Able to troubleshoot production environments for query performance issues Demonstrated ability to identify the bottlenecks in CPU and IO Significant experience with architecture and database design for SQL Server 2014 and later. Hands-on experience as a lead DBA supporting multiple database environments with a team. Experience with capacity planning, performance tuning and optimization of database environments.
Options to partition data. Options to access remote data. Strong understanding of SQL Server high-availability solutions and architecture:
Log shipping Always On Mirroring Strong experience with DB backup and recovery Able to handle shifting priorities and work in a team environment Good interpersonal skills Able to work remotely and support on call efforts



Desired Skills:



Data warehouse design experience Experience using Red Gate tools (SQL Compare, SQL Data Compare, SQL Source Control preferred)


Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

When you think of InComm Payments, think of Innovative Payments Technology. We were founded 25 years ago and continue to be a pioneer in the payment (FinTech) industry. Since our inception, we have grown to be a team of over 2,500 employees in 30 countries around the world. We own over 386 global technical patents and a network that includes over 500,000 points of retail distribution that points to our industry expertise.

InComm Payments works with the most recognized and valued brands in the world, and we are partnered with most of the world's leading merchants. InComm Payments is highly focused on our people and their growth, and we work hard to make a career at InComm Payments meaningful and rewarding. We value innovation, quality, passion, integrity and responsibility in all that we do, and we are looking for great people to join our team as we move forward towards a very bright future.

You can learn more about careers at InComm Payments here: www.incomm.com or connect with us on Twitter, Facebook, LinkedIn, or Our Blog.
Inside InComm from InComm on Vimeo.


About This Opportunity


The Manager is responsible for the Database Administration team managing databases that support InComm's business in a global, high-availability and high-performance environments.

The incumbent leads both technically and administratively the DBA in administering SQL and MySQL databases and applications, tuning to the best performance, and industry best practices. The database environments to support include but not limited to development, quality assurance, test, and production.


Responsibilities



Formal management of a team of SQL Server database administrators. Effectively lead a team and inspire others to achieve goals with a focus on automation, excellence, innovation, and quality. Ability to manage change and effectively communicate up and down the line to for smoother execution. Meet with client teams to understand requirements, conduct regular team meetings, and track progress. Conduct performance reviews of team members and identify areas of improvement, give feedback, and make recommendations for promotions or salary increments Provide technical leadership in design, implementation and support of the core database services that are highly reliable, flexible, scalable, and cost effective. Define policies, procedures, and standards to be implemented in database system. Oversee efforts to maximize database system availability, ensure swift and complete database recovery, optimizing database and availability through ongoing maintenance, and ensure conformance to audit and operating standards. Establish proper monitoring, measuring, and reporting of service performance against Service Level Objectives, customer satisfaction and financial efficiencies. Support staffing for 24X7 production environments. Manage risks, assessing gaps/opportunities, and implementing action plans to mitigate risks, when applicable Specific duties may vary depending upon departmental requirements.


Qualifications



Qualifications:


2+ years of leadership experience. 5+ years of database administration experience with SQL Server Databases Bachelor's Degree in Computer Science, Engineering, Information System, Information Technology, or related field required Experience in on premise database builds both virtual and physical servers as well as Azure cloud servers. A good knowledge & experience in using and configuring SQL Sentry Experience in migrating code, database changes and data through the various stages of the development life cycle and supporting 24X7 production environments


KSA (Knowlege, Skills, Abilities):


Ability to work a team dynamic that delivers a high availability service Demonstrated ability to document standard procedures, problems resolutions and environment modifications Strong interpersonal skills and good written and verbal communication skill Maintain high standards of work and composure in challenging situations Ability to follow all company policies and procedures as well as internal departmental procedures to ensure consistency in systems Ability to investigate and assess issues to make certain the correct solution is implemented Demonstrated ability to advance project timelines and effectively communicate status updates to stakeholders Ability to improve, optimize, and identify opportunities for improved software development processes Ability to support continuous process improvement and innovation


InComm provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity or national origin, citizenship, veteran's status, age, disability status, genetics or any other category protected by federal, state, or local law.


*This position is eligible for the Employee Referral Bonus Program - Tier III