Database Administration
Aptus Solutions Inc.,
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
Qualifications
- 5+ years of MSSQL experience.
- Experience working with large databases.
- Self-motivated with strong troubleshooting skills.
Responsibilities
- Maintain uptime of all database applications.
- Develop, test, and deploy SQL changes.
- Manage operations of database systems effectively.
- Test new software versions for database servers.
- Provide advice on database standards.
Skills
Job description
We at aptus solutions, as the definition suggests, provide the "best", "most suitable", "fitting" solutions, Products and Services to our clients in achieving their goals within Information Technology.
Aptus Solutions provides its clients extensive IT Solutions, Services and Products needed to become successful in within their business domain. Our IT services spans in three distinct Solutions and Services Categories:
IT Project Management Tools, Solutions and Services
Technology Outsourcing Solutions
IT (HCM)- Human Capital Management Solutions
The Database Administrator will be responsible for designing, implementing and maintaining production databases, SQL queries, procedures, scripts and objects, including tables, primary and foreign key relationships, triggers, constraints, etc.
In this role, you will perform advanced performance analysis and tuning within SQL Server, as well as the other tiers of the infrastructure, to identify and resolve bottlenecks and problems, and you’ll ensure that databases are working properly in conjunction with applications. You must have the ability to complete data mining efforts and ad hoc analysis to ensure a firm understanding of source system data and how it relates to business requirements.
And you will work closely with the development team to optimize SQL queries, support coding best practices and implement optimal coding techniques.
Our primary databases are MS SQL Server, but we also have production MySQL and PostgreSQL databases.
The MySQL databases range from a Drupal backend to a complex data warehouse. You must be an expert with SQL Server and have a willingness to become one with MySQL and Postgres.
- Maintain uptime of all database applications from a database perspective
- Develop, test and deploy SQL changes to production, quality assurance and development environments.
- Manage and monitor the day-to-day operations of database systems and ensure that the systems and applications function effectively
- Make sure that the database systems provide sufficient computing power to deliver the desired level of business performance.
- Test new software or software versions such as database server upgrades
- Understand SAN based storage and related technologies, specifically related to MS SQL Server installations.
- Provide advice to developers and users on database standards, data structures and terminology
- Prepare technical reports on the operation of systems.
- Assist with Windows Server configuration and management as it relates to MS SQL Server installation and performance.
- Perform scheduled maintenance and support release deployment activities after hours
- 5+ years MSSQL experience
- Experience working with very large databases.
- Exceptionally skilled in troubleshooting query performance
- Self-motivated individual
- Ability to analyze data to find inconsistencies
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
