Pioneer Services, the Military Banking Division of MidCountry Bank, is looking for an experienced Database Administrator to provide technical expertise in the design, implementation, and maintenance of relational database management systems. As a DBA you will provide 24x7 on-call rotation support for all production databases; as well as support of development database efforts from all business units.
Essential Duties and Responsibilities:
Responsible for the installation, configuration, troubleshooting, support and maintenance of Microsoft SQL Server database systems including Production, Test, and Development database environments.
Monitoring and optimization of database performance, security, resource utilization, memory configuration, sessions, archive logs, and disk space usage.
Share support for mission-critical database instances, including responsibility for after hours on-call support for issue resolution.
Assist application developers in the development of stored procedural code.
Tune SQL queries used by applications and provide suggestions to development for performance improvements in SQL and PL/SQL code.
Support Backup and Recovery procedures on SQL Server database systems.
3+ years as an SQL Server DBA.
4 year degree or equivalent diploma and work experience
SQL Server Software installation and new database setup
Oracle DataGuard experience in both logical and physical environments
Backup and recovery
Performance monitoring and tuning
SQL tuning experience.
Experienced in Packages, Procedures, and Triggers
SQL Server client configurations including ODBC data sources
24x7 production environment experience
Knowledge and Skills:
Able to work well under pressure and with multiple project deadlines.
Comfortable with team-based work structure; ability to remain flexible to change - within the work environment and scope of responsibility.
Demonstrates initiative, and provides complete follow-through on areas of responsibility.
Must have excellent problem solving skills.
Must have excellent verbal and written communication skills for both technical and non-technical associates.
Pioneer Services is an Equal Opportunity Employer.