Find Jobs
Hire Freelancers

DBA architect

₹1250-2500 INR / hour

Closed
Posted over 6 years ago

₹1250-2500 INR / hour

Looking for DBA Architect for long term, Monthly Payout 60k to 80K. Architecture recommendation, HA/DR, backup, long term retention, failover, DR procedures, staging procedures, o SQL Server 2012 and Upgrade of SQL Server o Patching and upgrading SQL servers from older versions o Tuning databases to improve query performance o Setting up security, auditing, monitoring performance and capacity constraints o Automating daily DBA manual tasks using jobs or scripts o Writing T-SQL or PL-SQL including stored procedures, functions and triggers - Experience in AlwaysOn BRD and FRD (Business Requirement Document and Functional Requirement Document) - Familiarity with SQL Diagnostic Manager or similar tools - Working knowledge of Windows Server administration, and Cloud technologies - Experience in creating requirement, technical, architectural documentation - Skilled at reviewing query performance and optimizing table indexes and structure to improve database performance. - Data modeling to visualize database structure, and designing and tables - Developing / troubleshooting SQL Experience in AlwaysOn BRD and FRD (Business Requirement Document and Functional Requirement Document) Need to Clear Client interview to get this Job.
Project ID: 15690796

About the project

26 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
26 freelancers are bidding on average ₹1,811 INR/hour for this job
User Avatar
Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
₹2,000 INR in 15 days
5.0 (79 reviews)
6.4
6.4
User Avatar
i am sql server dba having more then 8 yrs of expereince ...you can see my reviews and ratings.............................................................................................................................
₹1,388 INR in 40 days
4.6 (61 reviews)
5.4
5.4
User Avatar
I have rich skill with DBA Architecture project. o SQL Server 2012 and Upgrade of SQL Server o Patching and upgrading SQL servers from older versions o Tuning databases to improve query performance o Setting up security, auditing, monitoring performance and capacity constraints o Automating daily DBA manual tasks using jobs or scripts o Writing T-SQL or PL-SQL including stored procedures, functions and trigger
₹1,973 INR in 40 days
4.8 (5 reviews)
4.1
4.1
User Avatar
We are a team of expert DB architects and administrators with more than 10 years of rich industry experience on SQL server. We have worked extensively on MySQL,Oracle,MS-SQL Server,NoSQL and other Database Engines. Some of our key areas include: Designing DB schemas for large applications in various business domains like finance, health, energy etc. Troubleshoots long-running reports. Performance Bottlenecks. Data inaccuracies. In-efficient workflows & data inconsistencies in applications/reports. Expertise with ERP data, indexes, keys, views & relationships in an ERP database (1000+ tables). Our hard earned 5-star rating & great client reviews would help to gain confidence in our team, you can be sure of getting the best solution within time & budget. Please let me know the best time to discuss the project requirements in detail so that we can take it further.
₹2,000 INR in 40 days
5.0 (8 reviews)
3.8
3.8
User Avatar
I have good exp in Core Oracle DBA with IT industry and now am in SME and leading my client.. As I have good exp with below HA(Active-Passive) DataGuard - Failover / SwitchOver/DR, RMAN Backup and Restore via Netbackup / TSM/Veritas etc.. and Make it as long term retention in RMAN and Backup configuration. I have a B.E in (Computer Science Eng.) and 8+ years of Experience as an Oracle Database Administrator in IT industry. I have done my Oracle 11g (OCP) and ITIL certification, In my experiences range from Handling large Oracle Databases running on Solaris/Unix/Linux/HP-Unix/AIX/Windows that include RAC and OS Cluster databases servers with various Applications like Highly volatile OLTP, Data Ware Housing, HR, ELHR, SAP and Reporting databases. Fulfill DBA daily activities Including Installation as Standalone/RAC clusters 11g/12c database, Build DR setup as Standby databases ( perform Switch-over | Fail-over test), Applying Oracle Patching (PSU/CPU/Bug patches), Up-gradation from 10g to 11g etc., Migration from 10g/11g to 12c, RMAN Backup/Restore, Cloning/refresh of databases from production to Test DB, OVM (Oracle Virtual Manager) Support (Migration from VMware/Physical servers to OVM platform as V2V(Virtual to Virtual)/P2V(Physical to Virtual), AWS Support like RDS/EC2 instances, Performance Tuning (Query Level tuning/AWR/ASH/ADDM/Trace report analysis), User management, Space management, Capacity planning, Troubleshooting all kind of ORA errors/issues..
₹1,666 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I noticed from studying the job listing that you need candidates with strong management skills. A great manager needs to have excellent critical thinking skills in order to solve problems- and should be capable of delegating responsibilities. In my previous job- I identified a cooperation problem involving multiple departments and took steps necessary to correct it. Through strategic delegation- I gave each member of my team a very specific responsibility aimed towards improving interdepartmental communication. I also spoke with the manager of the other department involved and encouraged him to do the same. The end result was more effective communication- enhanced cooperation and improved productivity between both departments.
₹2,083 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked as a Database Developer , Database administrator on large projects . The projects were mission critical project . All the projects that i have worked on were completed within the stipulated time
₹1,333 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹1,333 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹1,666 INR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Microsoft Certified SQL Server DBA having a total of 8.9 years of experience. I went through the job description and it completely suits my profile.
₹2,333 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Our team having more than 15 years of SQL DBA experience and we give our best support to the project. Our team will support through remote, if required team will visit the Data Center place to work.
₹1,898 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 9 years of experience in development, I worked on large applications like ERP, HRMS, School Management System, Hospital Management System etc. in which backend was SQL Server. I Worked on different versions of SQL Server i.e. SQL Server 2000, SQL Server 2005, SQL Server 2008. In all my projects I was responsible for writing all the complex queries, triggers, sps, functions. I can handle SQL Server Database very easily.
₹1,500 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹1,444 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Have industry hands-on experience of 6+ Years working on Microsoft SQL as a DBA and PL/SQL developer. Also have expertise in query tuning / performance optimization and other dba related activity.
₹1,777 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm experienced with 7years as a database administrator. I have been working with 100s of relational databases running for various type of services such as CRM,Billing,Application and DataWarehouse
₹2,083 INR in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
mumbai, India
4.8
15
Payment method verified
Member since Nov 8, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.