Compensation Range:
70
Welcome to IntePros, a certified woman-owned company specializing in innovative and results-oriented recruiting and staffing solutions. We take immense pride in genuinely understanding what drives and inspires exceptional individuals like you. Your success is our priority, and we are dedicated to actively shaping your long-term career journey. At IntePros, we believe in comprehensive well-being. You have access to our medical, dental, vision, and mental health programs, ensuring your health and wellness are taken care of. To support your continuous growth, we also provide a $1,500 per year education and professional certification fund. Diversity and inclusion are cornerstones of our company ethos. IntePros is proud to be an equal opportunity employer. We do not discriminate in employment on the basis of race, color, religion, sex, pregnancy, gender identity, national origin, sexual orientation, disability, age, veteran or military status, retaliation, or any other characteristic protected by law. We celebrate the rich tapestry of backgrounds and perspectives that make us stronger as a team. Please note that only qualified individuals being considered will be contacted. We appreciate your interest and look forward to potentially embarking on a transformative journey together.
IntePros is seeking a Senior SQL Server Performance DBA who will collaborate closely with cross-functional IT teams—spanning Application Development, Server Administration, Networking, and more—to drive peak application and database performance. If you thrive in large-scale environments and bring hands-on experience in optimizing high transaction volumes, we want to hear from you! Extensive Java experience is essential, and while Mule experience is a plus, it's not a requirement.
Specific Duties :
- Advanced Database Development experience with Microsoft SQL Server Database.
- Experience with Senior level Database Administration support. (e.g., Installing / Upgrading / Backup and Recovery / Configuring / SSMS / SSIS / SSRS / Always on Failover Clustering / Performance Tuning / Troubleshooting ).
- Evaluating SQL Server Query performance. Providing guidance on query redesign, index modifications, database configuration changes, and database related application process improvements.
- Utilizing Idera SQL Diagnostic monitor, Query Store, SQL Server Profiler, Dynatrace and Query plans to evaluate and tune database queries. Evaluating index statistics/fragmentation.
- Creation of SQL Server performance documentation/best practices for consumption by SQL Server Database Development and Database Administration teams.
- Participate in evaluations and recommendations for associated database solutions based on business requirements and user needs.
- Provide performance monitoring and measuring of all database components and provide input on capacity and performance planning.
- Escalate issues for technical assistance as required.
- Participate in basic to moderately complex database tuning efforts as required.
- Apply administration best practices in daily operations.
Qualifications :
- BA/BS in Computer Science, Information Systems, or related field, or equivalent knowledge acquired by work experience and training.
- Industry-recognized technical certification preferred (e.g. SQL, MCDBA)
- Working Knowledge of database file structure, retrieval and access methods, and performance analysis. Demonstrated analytical skills, excellent written and verbal communication skills, judgment, and the ability to work effectively with clients and IT associates in a collaborative and cooperative manner. Basic Understanding of the development process and business process.
- Ten (10) or more years related IT experience working as a SQL Server database administrator and familiarization with related technologies and tools.
- The candidate should have Database Development experience in large scale environments with high transaction volumes such as ecommerce or banking.
