Role & Responsibilities: Creates and maintains all databases required for development, testing, education and production usage. Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff. Plans and implements backup and recovery of the MSSQL database. Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle. Implements and enforces security for all of the MSSQL Databases. Performs database re-organisations as required to assist performance and ensure maximum uptime of the database. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to. Evaluates releases of MSSQL and its tools, and third-party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact. Provides technical support to application development teams. This is usually in the form of a help desk. Enforces and maintains database constraints to ensure integrity of the database. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Troubleshoots with problems regarding the databases, applications and development tools. Requirements Bachelor's degree in It or related studies. DBA should have sound communication skills with management, development teams, vendors, systems administrators and other related service providers. Must be a self-starter with a strong attention to detail. Good knowledge of the Unix Operating system(sz)Skills in project management tools. Ability to develop and maintain collaborative and cooperative relationships throughout the organization. Proficient application of IT best practices for Waterfall and Agile projects. Experience working with AWS. Experience with Jira, Confluence, and Slack, etc. Experience with other database tools such as and not limited to PostgreSQL, Cassandra, MongoDB, Microsoft SQL Server,Azure database, Azure Cosmos DB. Azure Synapse Analytics..
Role & Responsibilities:
- Creates and maintains all databases required for development, testing, education and production usage. Performs the capacity planning required to create and maintain the databases.
- The DBA works closely with system administration staff. Plans and implements backup and recovery of the MSSQL database.
- Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
- Implements and enforces security for all of the MSSQL Databases.
- Performs database re-organisations as required to assist performance and ensure maximum uptime of the database.
- Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
- The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
- Evaluates releases of MSSQL and its tools, and third-party products to ensure that the site is running the products that are most appropriate.
- Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
- Provides technical support to application development teams. This is usually in the form of a help desk.
- Enforces and maintains database constraints to ensure integrity of the database. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
- Troubleshoots with problems regarding the databases, applications and development tools.
Requirements
- Bachelor's degree in It or related studies.
- DBA should have sound communication skills with management, development teams, vendors, systems administrators and other related service providers.
- Must be a self-starter with a strong attention to detail.
- Good knowledge of the Unix Operating system(sz)Skills in project management tools.
- Ability to develop and maintain collaborative and cooperative relationships throughout the organization.
- Proficient application of IT best practices for Waterfall and Agile projects.
- Experience working with AWS.
- Experience with Jira, Confluence, and Slack, etc.
- Experience with other database tools such as and not limited to PostgreSQL, Cassandra, MongoDB, Microsoft SQL Server,Azure database, Azure Cosmos DB. Azure Synapse Analytics..
Two95 International Inc., is a global technology firm specializing in
enterprise solutions that evolves over BPM, Mobility, Cloud, Analytics,
E-commerce & Social Business. Our client base includes several
Fortune 500 and mid-market companies across industries and varying
geographies.With vast knowledge and knowhow of 20 years in the IT field, we have
been chosen as INC500 fastest growing company in North America in 2013.
With the accolade of being ranked 11th in Human Resources by INC500, we
have also been nominated as the 3rd fastest growing company in South
Jersey by SJBM. We are ranked among the Top 20 IT Companies in New
Jersey based on the year-on-year growth for the last 3 years. With a
seasoned team of highly qualified personnel, our offices are located in
New Jersey, Canada and India.Our Specialties
Direct Hire,
Contingent Staffing,
Managed Outsourced Services..
Two95 International Inc., is a global technology firm specializing in
enterprise solutions that evolves over BPM, Mobility, Cloud, Analytics,
E-commerce & Social Business. Our client base includes several
Fortune 500 and mid-market companies across industries and varying
geographies.
With vast knowledge and knowhow of 20 years in the IT field, we have
been chosen as INC500 fastest growing company in North America in 2013.
With the accolade of being ranked 11th in Human Resources by INC500, we
have also been nominated as the 3rd fastest growing company in South
Jersey by SJBM. We are ranked among the Top 20 IT Companies in New
Jersey based on the year-on-year growth for the last 3 years. With a
seasoned team of highly qualified personnel, our offices are located in
New Jersey, Canada and India.
Our Specialties
Direct Hire,
Contingent Staffing,
Managed Outsourced Services..
